RMD Business Excel 2007 VBA Syllabus
This course is designed for delegates who have strong experience of using
Microsoft Excel 2007 and want to learn the Visual Basic for Applications features.
If the course syllabus does not entirely match your requirements, please contact us
as we are able to customise it to your needs.
This course has a duration of 2 days.
Excel 2007 VBA
Macros
Recording and Debugging Macros
VBA Projects, Modules and Procedures - structure and coding
Running macros - Keys, Buttons, Events and Menus
Writing and using User Defined Functions
Variables and Constants - Declaration, assignment & scope
Calling procedures and passing parameters
Objects & Collections - Properties, Methods & Object Browser
Showing message boxes and reading button presses
Reading input via INPUTBOX
Flow of Control commands (IF, SELECT, FOR, DO, WHILE etc)
Arrays in Excel
VBA OLE Automation within and from Excel
Web Publishing automation in VBA
Using Excel Dialogue boxes and creating your own User Forms
Adding controls to the User Form
Coding in the User Form
Creating and amending Command Bars and Toolbars
Debugging Macros, Breaks, Watches & Run Time errors
