Basics of VBA / Macros Chapter – 56 (Events Part-5)
Bills and Coins Below we will look at a program in Excel VBA that splits an amount of money into bills and coins. Situation:…
Read article →Category Archives: Excel VBA
Step-by-step VBA lessons and ready-to-use macros.
Basics of VBA / Macros Chapter – 55 (Events Part-4)
Basics of VBA / Macros Chapter – 55 (Events Part-4)
Create a Footer Before Printing Below we will look at a program in Excel VBA that creates a footer before printing a workbook. Create…
Read article →Basics of VBA / Macros Chapter – 54 (Events Part-3)
Basics of VBA / Macros Chapter – 54 (Events Part-3)
Highlight Active Cell Below we will look at a program in Excel VBA that highlights the row and column of the Active Cell (selected…
Read article →Basics of VBA / Macros Chapter – 53 (Events Part-2)
Basics of VBA / Macros Chapter – 53 (Events Part-2)
BeforeDoubleClick Event Code added to the Worksheet BeforeDoubleClick Event will be executed by Excel VBA when you double click a cell on a worksheet.…
Read article →Basics of VBA / Macros Chapter – 52 (Events Part-1)
Basics of VBA / Macros Chapter – 52 (Events Part-1)
Events Events are actions performed by users which trigger Excel VBA to execute code. Workbook Open Event Code added to the Workbook Open Event…
Read article →Basics of VBA / Macros Chapter – 51 (Time and Date Part-8)
Basics of VBA / Macros Chapter – 51 (Time and Date Part-8)
Sort Birthdays Below we will look at a program in VBA that sorts birthdays to months first and days second (so we ignore years).…
Read article →Basics of VBA / Macros Chapter – 50 (Time and Date Part-7)
Basics of VBA / Macros Chapter – 50 (Time and Date Part-7)
Tasks on Schedule Below we will look at a program in Excel VBA that sets the background color of tasks that are on schedule…
Read article →Basics of VBA / Macros Chapter – 49 (Time and Date Part-6)
Basics of VBA / Macros Chapter – 49 (Time and Date Part-6)
Year Occurrences Below we will look at a program in Excel VBA that counts the number of year occurrences. Situation: Dates are in US…
Read article →Basics of VBA / Macros Chapter – 48 (Time and Date Part-5)
Basics of VBA / Macros Chapter – 48 (Time and Date Part-5)
Delay a Macro To execute a sub in Excel VBA after a specific time, use onTime, Now and the TimeValue function. First, place a…
Read article →Basics of VBA / Macros Chapter – 47 (Time and Date Part-4)
Basics of VBA / Macros Chapter – 47 (Time and Date Part-4)
Weekdays Below we will look at a program in Excel VBA that calculates the number of weekdays between two dates. Weekdays are: Monday, Tuesday, Wednesday,…
Read article →Basics of VBA / Macros Chapter – 46 (Time and Date Part-3)
Basics of VBA / Macros Chapter – 46 (Time and Date Part-3)
DateDiff Function The DateDiff function in VBA can be used to get the number of days between two dates. Place a command button on…
Read article →Basics of VBA / Macros Chapter – 45 (Time and Date Part-2)
Basics of VBA / Macros Chapter – 45 (Time and Date Part-2)
Compare Dates and Times How to compare dates and times in VBA. Dates and times are stored as numbers in Excel and count the…
Read article →