VBA Skills Library

Easy

• Enabling the Developer tab and opening the VBA editor
• Recording your first macro
• Understanding the VBA editor (Project Explorer, Immediate window)
• Message boxes and input boxes
• Assigning macros to buttons

Intermediate

• Variables and data types
• If…Then…Else statements
• Working with ranges and cells
• Looping through rows with For…Next and Do While
• Debugging tips (breakpoints, F8, Watch window)

Advanced

• Creating a custom function (UDF)
• Error handling with On Error
• Automating repetitive tasks (formatting, copying data)
• Looping through worksheets and workbooks
• Working with arrays
• Building UserForms
• Controlling Word and Outlook from VBA