Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

Loops and conditions in VBA macros blogs

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.
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.
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!

All content copyright Wise Owl Business Solutions Ltd 2014. All rights reserved.