Byron Employment

Byron Employment. Over 162,626 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $740.00

Do you need to

• Build and edit recorded macros in Visual Basic
• Create customised menus and dialog boxes suitable for use by End Users
• Create user defined functions
• Work with the Visual Basic editor
• Use variables effectively in VBA programming

Pre-requisites:

Excel Advanced – Data Analysis & Automation or have a good understanding of the advanced features of Microsoft Excel.

At the End of this Course:

You should be able to
• Use the macro recorder to record Excel operations
• Use the recorder to create working applications
• Create user defined functions
• Work with the Visual Basic Editor
• Work with procedures and the coding in them
• Work with Excel Object Model
• Work with conventional programming techniques
• Create custom forms
• Customise the menu system to run VBA procedures
• Work with automatic startup and automatic shut down procedures

Course Content

Recorded Macros
• Recording and Running a Simple Macro
• Relative Recording
• Modifying a Recorded Macro
Recorder Workshop
• Recording Summation, Averaging, Maximum,
• Minimum and Divisional Macros
User Defined Functions
• Creating and User Defined Function
• Passing Multiple Arguments
• Creating and Modifying a Function
Using the VBA Editor
• Working with the Project Explorer
• The Properties Window
• Working with A Code Module
• Procedures and Break Points in the Editor
Understanding VBA
• Working with Object Collections
• Setting Property Values
• Working with Worksheets
• Programming with the Object Browser
Procedures
• Creating a Command Procedure
• Making sense of IntelliSense
• Using the Edit Toolbar
• Commenting Statements
Using Variables
• Creating and Using Variables
• Implicit and Explicit Declarations
• Procedure Level &Module Level Scoping
• Passing Variables by Reference or Values
Using Excel Objects
• Using the Workbook & Worksheet Objects
• Using Range Objects
Program Techniques
• Communicating with the User
• Using the Input Method
• Using IF to make Decisions
• Testing for Multiple Conditions

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 6162 2929
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 6162 2929 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search