Create Multiple Names Using VBA in Excel with One Click
Need to create multiple names using VBA in Excel instead of adding them one by one in Name Manager? In this tutorial you build a small macro that turns every
Tag: Excel Tips
Highlight and Count Birthdays from Date of Birth in Excel
Want to count birthdays from date of birth in Excel and highlight who is celebrating this month? In this tutorial you build a small birthday tracker from a plain employee
Insert a Picture in Excel Comments (Notes): Show Image on Hover
To insert a picture in Excel comments, you fill the comment box with an image instead of text, so the picture pops up only when someone hovers over the cell.
33 Useful VBA Shortcut Keys (Full List with Examples)
These 33 useful VBA shortcut keys help you write, test and debug macros faster and lay out UserForms in seconds instead of minutes. Below you will find all 33 in
Protect Excel Worksheet as UserInterfaceOnly with VBA
When you protect an Excel worksheet as UserInterfaceOnly, the sheet stays locked for people but stays open for your VBA macros. That solves two everyday problems. First, a macro that
Highlight Unmatched Cells in Excel with Conditional Formatting
To highlight unmatched cells in Excel, you compare each value with a second list and colour the ones that are missing from it. A typical case: your sales sheet contains
Highlight Consecutive Duplicates in Excel with a Simple Formula
To highlight consecutive duplicates in Excel, you only need one conditional formatting rule with a short OR formula. It colours a value only when the same value sits directly above
Merge Cells with Same Value in Excel Using VBA (Quick Macro)
Need to merge cells with same value in Excel without clicking Merge & Center a hundred times? A short VBA macro does it for you. Select the range, run the
VBA.InputBox vs Application.InputBox in Excel VBA (7 Types)
VBA.InputBox vs Application.InputBox is one of the first choices you make when a macro needs to ask the user for something at run time. Both show a small dialog with
Checkbox in Excel Table: Highlight Rows and Sum Checked Items
A checkbox in an Excel table is one of the quickest ways to let users pick rows. In this Excel tip you put one Form Control check box in every