Excel Macros for Professionals

Start the VBA editor,Object properties,Methods,Attach code to events and buttons, Use the object browser,Programming basics,Variables and data types,Expressions,Manipulating data, Getting input from the user in Input and Message boxes, Variables and scope, Procedures, Calling one procedure from another, Using loops, Do / while, For / Next, If...Else..End..If, Select Case...Case 1,2,3, Else...End Else,User Forms,Creating a dialog box (user form),Displaying a dialog box,Using text boxes and labels,Using command buttons,Using combo and list boxes,Error handling Identifying compile-time, run-time and logical errors in code,Use the debugging tools Write error handling code to trap errors