MS Excel 2007 VBA

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: The 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.