Excel Programming Weekend Crash Course (Paperback)

FRIDAY. PART I--Friday Evening. SESSION 1-Microsoft Excel Programming--Why and How. SESSION 2-The VBA Code Editor. SESSION 3-The Excel Object Model. SESSION 4-Syntax and Data in VBA. SATURDAY. PART II-Saturday Morning. SESSION 5-Operators. SESSION 6-Control Constructs. SESSION 7-Procedures and Modules. SESSION 8-Working with Dates and Times. SESSION 9-Working with Text. SESSION 10-Using Ranges and Selections. PART III-Saturday Afternoon. SESSION 11-Working with Columns, Rows, and Cells. SESSION 12-Programming with Custom Formulas. SESSION 13-Programming with Excel's Built-In Functions. SESSION 14-Formatting a Worksheet. SESSION 15-Find and Replace Operations. SESSION 16-Creating Custom Toolbars. PART IV-Saturday Evening. SESSION 17-Introduction to Charts. SESSION 18-Advanced Charting Techniques. SESSION 19-Creating Custom Dialog Boxes with User Forms. SESSION 20-Controls for User Forms. SUNDAY. PART V-Sunday Morning. SESSION 21-Advanced User Form Techniques. SESSION 22-A User Form Example. SESSION 23-Working with Events. SESSION 24-Security Considerations. SESSION 25-Debugging and Distributing an Application. SESSION 26-Defining and Using Custom Classes. PART VI-Sunday Afternoon. SESSION 27-Handling Runtime Errors. SESSION 28-Database Tasks. SESSION 29-Creating Add-Ins. SESSION 30-Adding Online Help to Your Application. Appendix A-Answers to Part Reviews. Appendix B-What's on the Web Site. Index.