Ad space (banner)
📊VBA Lessons
- 01Setting up (what you'll need)
- 02Your first output (MsgBox)
- 03Variables (Dim)
- 04Branching (the If statement)
- 05Repeating (the For statement)
- 06Repeating (the Do While statement)
- 07Writing a Sub procedure
- 08Function procedures (work that returns a value)
- 09Reading and writing cells (Range and Cells)
- 10Working with arrays
- 11Working with strings
- 12The With statement
- 13Object variables and working with worksheets
- 14Looping over cells (For Each)
- 15Error handling (On Error)
- 16The Select Case statement
- 17Arguments (ByVal and ByRef)
- 18Working with collections (Collection)
- 19Recording macros and event procedures
- 20[Project] Build a small inventory sheet
Lesson 1 / 20
Setting up (what you'll need)
To run VBA you will need the following. VBA is the language for driving and automating Microsoft Office applications such as Excel and Word, and its development environment is built into Office itself.
- Microsoft Excel: the Windows version of Excel includes VBA editing as standard.
- The VBE (Visual Basic Editor): press
Alt + F11in Excel to open it. This is where you write your code. - To save a macro, the file has to be saved as an Excel Macro-Enabled Workbook (.xlsm).
← Previous lesson
Next lesson →
Ad space (banner)
Ad space (in-article)