BY TOPIC
EXCEL / VBA BLOGS
VBA MACROS BLOGS
- Recording macros (1)
- Working with ranges (4)
- Input/message boxes (3)
- Variables, arrays (3)
- Enumerations (2)
- Loops and conditions (2)
- Errors and debugging (2)
- Functions / arguments (3)
- Events (2)
- User forms (6)
- Classes (4)
- References (9)
- Files and folders (4)
- General (12)
- Working with charts (4)
- Flappy Owl (14)
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on Loops and conditions in VBA macros
Showing blogs 1-2 (out of 2)
Looping in Visual Basic for Applications macros
Posted by Andy Brown on 15 November 2011
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
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.