Blogs from Wise Owl on Loops and conditions in VBA macros
Showing blogs 1-3 (out of 3)
Posted by Andy Brown on 15 November 2011 | 5 comments
There are 4 types of loop in Visual Basic for Applications - this blog shows how and when to use each type of VBA loop structure.
Posted by Andy Brown on 15 November 2011 | no comments
This part of the Excel VBA training series of blogs shows how to use IF / ELSE / END IF within VBA, and also how to use the alternative SELECT / CASE syntax within macros.
Posted by Andrew Gould on 01 July 2011 | no comments
Setting up a pattern of working time in a Project calendar is simple enough when your week runs from Monday to Sunday, but when you have an unusual working pattern setting up the calendar is a pain! This article explains how to use VBA to create a detailed calendar at the click of a button!
MS OFFICE BLOGS
VBA MACROS BLOGS
BLOGS BY AUTHOR
BLOGS BY YEAR