| MICROSOFT EXCEL |
Variables and Constants• Variables• Data Types • Constants Control Structures• Conditional Control Structures• Looping Control Structures • Non-structured statements • Sub Procedures Controls & Userforms• Built-in dialogue boxes• Predefined dialogue boxes • Controls • Custom dialogue boxes • Assigning procedures to a dialogue box Menus & Toolbars• Customised menus• Managing menus • Toolbars • Tooltips Testing & Debugging• Types of errors• Break mode • Instant watch • Stepping Event Triggered procedures• Creating automatic procedures• Creating event procedures Function ProceduresAdd-in Applications | |
| VISUAL BASIC FOR APPLICATIONS | ||
| Duration - 2 Days | ||
|
Delegates should have completed and Introductory and Advanced Excel course prior to attending. Alternatively they should have a good working knowledge of the advanced features in Excel. Introduction• What is a Macro• Recording a Macro • Running a Macros • Relative references • The Macro toolbar Assigning Macros to Buttons and Objects• Adding Macros to the Menu Bar• Assigning Macros to sheet buttons • Assigning Macros to toolbar icons Editing Macros• Editing a Macro• Procedures • Inserting comments • Printing a VBA Module The Range Object• Cells method• Range method • Flexible ranges • Virtual worksheets • Range contents Objects, Properties & Methods• Controlling objects with properties• Performing actions with methods • Performing multiple actions |
||
