Excel VBA programming

Starting Excel VBA programming. Getting to know VBA ; Building simple macros

Using VBA with Excel. Working in the visual basic editor ; Introducing the Excel object model ; VBA sub and function procedures

Creating code automatically. Using the Excel macro recorder ; Generating code with copilot

Programming concepts. Essential VBA language elements ; Working with range objects ; Using VBA and worksheet functions ; Controlling program flow and making decisions ; Automatic procedures and events ; Error-handling techniques ; Bug extermination techniques ; VBA programming examples

Communicating with your users. Simple dialog boxes ; UserForm basics ; Using UserForm controls ; UserForm techniques and tricks ; Accessing your macros through the user interface

Putting it all together. Creating worksheet functions ; Creating Excel add-ins

The part of tens. Ten handy visual basic editor tips ; Resources for VBA help ; Ten VBA do's and don'ts.