Microsoft Excel Visual Basic for Applications
Course
In Worthing
Description
-
Type
Course
-
Location
Worthing
-
Duration
2 Days
Facilities
Location
Start date
Start date
About this course
A good working knowledge of the skills acquired in the advanced course. It is a good idea to check the advanced outline first.
Reviews
Subjects
- Basic
Course programme
Training Course Outline:
Creating Record Macros
- Recording a Macro
- Running a Macro
- Running a Macro from the Macros Dialog Box
- Creating a Short-cut key to run a macro
- Running a Macro with a Shortcut key
- Assigning a Macro to a Menu or Toolbar
- Editing a Macro with Visual Basic
Visual Basic Editor
- Objects
- Methods
- Properties
- Programming Tools
- The Menu Bar
The Project Explorer
- Using the Project Explorer
The Properties Window
- Changing a Property
Using Constants
- Excel Constants
- Variable Constants
Excel Objects
- Objects, Properties and Methods
- Getting & Setting Properties
- Calling Methods
- Passing Arguments
- Singular Objects & Collections of Objects
Variables
- Dimensioning a variable
- Using variables in routines
- Object Variables
Using Visual Basic Functions
- InputBox Function
- MsgBox Function
- Using a Set Statement
Building Formulae
Control Structures
- If…Then Decision Structures
- Logical Operators
- Select Case Decision Structures
- Case Else
- Comparison Operators with Select Case Structure
- For… Loops
- Do Loops
- While...Wend Statement
UserForms
- Designing & Creating Forms
- Working with Controls
- Creating Custom Dialog Boxes
- Userform Properties Methods & Events
Event Handling
- VBA Editing & Debugging
- Auto Macros
- Error Handling
Microsoft Excel Visual Basic for Applications