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 (15)
- Working with charts (4)
- Flappy Owl (14)
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on Variables, arrays in VBA macros
Showing blogs 1-3 (out of 3)
How to use environment variables like USERNAME in VBA
Posted by Andy Brown on 25 November 2013
You can get at all sorts of system information within Visual Basic for Applications by using environment variables - this blog shows you how to get at your user's name, computer name and much more besides.
Arrays in Visual Basic for Applications macros
Posted by Andy Brown on 24 February 2012
You can use arrays (multiple variables) in VBA to speed up code - and they are also invaluable for processing CSV files and the like.
Variables and Constants in Excel Visual Basic
Posted by Andy Brown on 05 September 2011
This blog explains the nuts and bolts of Excel VBA variables, including how to declare them, how to set their scope and all sorts of other tips and tricks. The blog also covers constants in Excel macros.