VBA101: A practical guide for VBA user

I wrote this guide a few months ago (September, 2010) and I think it might be something useful for people, who are interested in VBA (Visual Basic for Applications).

Things to know

1. VBA stands for Visual Basic for Applications
2. VBA only works with Microsoft Office for Windows
3. VBA allows user to programmatically use Microsoft Office
4. Press Alt+F11 to jump to Visual Basic Editor view

VBA can …

1. Automatically update the document
2. Connect to database and populate information
3. Do Forms

How to write a Hello World in VBA

Sub MyHelloWorld()
MsgBox “Hello World”
End Sub

Note about VBA

1. Comment is ‘
2. No ; at the end of the line
3. No {} for block code
4. Use Dim to declare variable
5. Assigning values to Primitive types do not require Set

Advertisement