Contents:
| Recording Code in Excel |
Controlling Program Flow |
| · Using the Personal Workbook |
· Conditional Structures |
| · Replaying Code |
· If…Then Decision Structures |
| · Placing Buttons on Worksheets |
· Logical Operators |
| · Creating Toolbar Buttons to run Macros |
· For and Do Loops |
| · Editing the Menu Bar to run Macros |
· While...Wend Statement |
|
· Select Case Decision Structures |
| Working with Visual Basic Editor |
|
| · Navigating in the Project Window |
Debugging |
| · Using the Properties Window |
· Using the break mode |
| · Opening the Code Window |
· VBA Editing and Debugging |
|
|
| Writing Code |
· Using Standard VB Functions |
| · Types of Procedures |
· InputBox and MsgBox Function |
| · Entering Code |
· Using a Set Statement |
|
|
| Running Code |
Creating and Using Forms within Excel |
| · Run mode and design mode |
· Adding a Form to a Project |
| · Running Code from the Development Environment |
· Add Controls and set Properties |
| · Running Code from the Host Application |
· Displaying a Form |
|
· Working with Form Events |
| Reusing Code |
|
| · Exporting a File |
Using Microsoft Excel Objects |
| · Importing a File |
· Opening and Saving Workbooks |
|
· Workbook events |
| Using Visual Basic for Applications |
|
| · Using Variables |
Using Worksheets |
| · Lifetime and scope of variables |
· Inserting and Reading Data from Cells |
| · Using and writing Sub Procedures |
Using VB Objects, Methods and Properties to |
| · Using and writing Function Procedures |
Manipulate, Read and Analyse Data in a Spreadsheet |
Target Audience:
Assumed Knowledge: Delegates must be proficient in the use of Excel. Previous programming experience is not necessary
Duration:
2 Days - Click here to see our course calendar.
Suggested follow-up course: