Blogs from Wise Owl on Loops and conditions in VBA macros

Showing blogs 1-3 (out of 3)

Looping in Visual Basic for Applications macros

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.

Conditions in Visual Basic for Applications - IF and SELECT CASE

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.

Using VBA in Microsoft Project to Set Up Unusual Calendars

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!