Microsoft Excel VBA (Visual Basic Applications)
| Course Title: | Microsoft Excel Visual Basic Applications (VBA) |
| Aims: | To illustrate how to use macro programming to speed repetitive tasks when employing Microsoft Excel |
| Pre-requisites: | Delegates MUST be familiar with the use and exploitation of Microsoft Excel at an Advanced level |
| Duration: | Two Days |
| What is a Macro Recording macros Running macros Relative referencesAssigning Macros To Objects To the Quick Access Toolbar Editing Macros The Visual Basic Editor The Project Explorer The Code Window Procedures The Range Object Objects, Properties and Methods Display Dialogue Boxes Conditional Control Structures |
Handling Text Line Continuation Character Line breaks in text Formatting Text Functions Variables and Constraints Variables Data Types Arrays Constants Looping Control Structures Function Procedures Debugging and Error Trapping Workbooks and Sheets User-Defined Forms |
