MS Excel 2007 VBA
Training
In London
Description
-
Type
Training
-
Location
London
-
Duration
2 Days
This course will show you how to Automate and Simplify complex tasks in Excel. At the end of the course, users will be able to record and run macros, edit the VBA code, build in loops structures and create custom forms.
Facilities
Location
Start date
Start date
About this course
Delegates would need to have strong Excel skills
Reviews
Subjects
- MS Excel
Course programme
Concept, Recording and Running Macros, the VBE Environment
- The Project Window
- Code Window
- Properties Window
- Navigating between Excel and the VB Editor
Editing Code + Methods of Executing
- Using the Visual Basic Editor
- Structure of a sub routine
- Key Words
- Navigation in a Module
- Editing in a module
- Use of Function Keys
- Run subroutines together
- Menu, Visual Basic Toolbar, Keyboard Shortcut, Custom Toolbar Button, Custom Menu Item, Forms Toolbar executing
Visual Basic Language Rules
- Theory of Object
- Properties and Methods
- Active Objects
- Object Model Hierarchy
- Inheritance
Control Structures
- IF, Nested IF
- AND OR NOT
- SELECT CASE
- Inbuilt Functions
- Distribution, Watch Pane
- Step through Functions using the immediate Window
Looping Structures
- Do Loops
- For Next Loops
- For Each Next Loops
Interactive Macros
- Msgbox
- Conditional Message Box
- Inputbox
Interactive Macros
- Msgbox
- Conditional Message Box
- Inputbox
Creating Interactive Forms
- Form Controls
- User forms
- Using the Properties Window
- Combo box
- Radio Buttons
- Group box
- Check box
- Built in Dialog Boxes
- Creating Custom Menus
- Creating Custom Toolbars
Events
- What are Event Procedures?
- On Open
- Before Close
- On Activate
- On Deactivate
- On Key
- On Time
Security
- Protecting/locking code for view/edit
- Digital Signatures
Time: Course starts at 09:30 and runs until 16:30
The course is run on a date that suits you! We do not run public scheduled courses.
Additional information
MS Excel 2007 VBA