VBA

How to count occurrences of each year in Excel?

Apr 20, 2020

Normally we can apply the COUNTIF function to count items with criteria in Excel. But, do you know how to count dates by year/month/weekday only?

How To Loop Through UserForm Controls Dynamically in Excel

Apr 20, 2020

how to loop through 200 checkboxes and to affect the appropriate textboxes based on whether they were checked or not.

Step Keyword in Excel VBA

Apr 20, 2020

You can use the Step keyword in Excel VBA to specify a different increment for the counter variable of a loop. This video explains how to do the same. You can use the Step keyword in Excel VBA to specify a different increment for the counter variable of a loop. Place a command button on your worksheet and add the following code lines: Dim i As Integer For i = 1 To 6 Step 2 Cells(i, 1).