THE CONCEPT, RECORD AND RUN MACROS & THE VB 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

Navigate a Module

Edit 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

Using a Msgbox

Use a Conditional Message Box

Use the Inputbox

CREATE INTERACTIVE FORMS

Build Form Controls

Build User forms

Use of the Properties Window

Combo box

Radio Buttons

Group box

Check box

Built in Dialog Boxes

Create Custom Menus

Create Custom Toolbars

EVENTS

What are Event Procedures?

On Open event

Before Close event

On Activate event

On Deactivate event

On Key event

On Time Event Security

Protect/lock code for view/edit

Digital Signatures