VBA For Excel

Silicon Beach Training Ltd.
Brighton, East Sussex, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' This VBA for Excel training course is designed to give a good working knowledge of Visual Basic for Applications �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.

Excel with VBA Training Course Content
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
...''

Elements of this syllabus are subject to change.

Phone:+44 (0)1273 622272

School Address/Venue(s):

86 Gloucester Road
Brighton
East Sussex
BN1 4AP
UK

Jobs & Resumes: Brighton
Houses & Roommates: Brighton

Search other schools for VBA For Excel training resources.

Sales Management
Telephone Sales
Customer Relationship Management
NLP for Sales
Negotiation Skills
Marketing
Sales & Marketing
Project
Excel
Access
Outlook
Word
Powerpoint
Mac
PC and the Internet
Visio
Crystal Reports
Sage Instant Accounting

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent.