|
Provided by: silicon beach training VBA For Excel TrainingTraining, Instruction and Documentation |
 |
Training
Provided by silicon beach training
This VBA for Excel training course is designed to give a good working knowledge of Visual Basic for Applications a concentrating on Microsoft Excel. During this VBA for Excel Training Course students will learn to create and edit macros, and gain an understanding of VBA code.
The Visual Basic for Applications content of the training course can be applied to other Microsoft Applications.
|
|
||||||||||||||||
VBA For Excel Training Seminar Schedule
| Date | Location | |||
|---|---|---|---|---|
| [Register] | ||||
| [Register] |
VBA For Excel Training
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
Running Code
Run mode and Design mode
Running Code from the development environment
Running Code from the host application
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 Formular 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
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
Running Code
Run mode and Design mode
Running Code from the development environment
Running Code from the host application
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 Formular 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
About The Training Provider: silicon beach training
silicon beach training - Silicon Beach Training is a recognised leader in IT, Design, Business and Management training courses throughout Europe. Our flexible, creative and innovative methods bring out the potential of your people and your organisation to achieve exceptional results.
Our comfortable training facilities are available in the UK, Brighton, 45 mins by rail from London.
Our clients tell us it"s...
