VBA for Excel

Technology Intellect
Cairns, QLD, Australia

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

Course Description:

'' Programming in Excel offers the potential to control Excel to the ultimate. If you would like to get the maximum from this application, you need to know how to write code in the language it understands, VBA. It is also one of the easiest languages to learn.
This course covers automation and customising of Excel using macros and screen items (such as buttons and menus). Delegates learn how to write macros using VB code and assign macros to screen items.

Course Contents

Introduction and the Macro Recorder

Demonstration
Recording a macro
Recording a macro with absolute references
The personal macro workbook
Assigning shortcut keys
Deleting macros
Recording a macro with relative references

Creating and Editing Macros With VBA

Macro storage concepts
The VBA program (the VB editor)
The program components
Storing and handling macros (modules)
Introduction to editing code
Copying and pasting procedures
Linking procedures together
Create and use a user-defined function
Auto-executable macros

Objects and Dialog Boxes

Introduction to objects
The object browser
Using the object browser and searching it
Built-in dialog boxes
User defined dialog boxes (message boxes and input boxes)

Introduction to Controls

Assigning macros to toolbar buttons (icons)
Customising the excel screen
Worksheet controls
User forms
Custom menus



...''

Phone:+61 7 4057 7891

School Address:

Suite 46 Campus Shopping Village, Smithfield, Cairns, Australia.

Jobs & Resumes: Cairns
Houses & Roommates: Cairns

Publisher Level 1
Project Level 2
MYOB
MYOB payroll
SQL Server
SQL Database Programming
Photoshop
ASP.NET 2.0
Visual Basic.NET
VBA for Access
VBA for Word

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: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.