Starting Excel VBA programming. Getting to know VBA ; Building simple macros -- Employing VBA with Excel. Working in the Visual Basic Editor ; Introducing the Excel object model ; VBA sub and function procedures ; Using the Excel macro recorder -- 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 ; Resurces for VBA help ; Ten VBA do's and don'ts.
