Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 0

This course builds on the Level I course. Topics include: creating custom functions, public vs private declarations, working with ranges, working with files, select case, creating and designing user forms and custom dialog boxes, and returning arrays.

Course Outline

This course builds on the topics covered in the first Macros course, and covers further techniques and examples for programming Excel with VBA.

This course is classroom style instruction: Instructor-led, hands-on training.

Custom Functions
Why Create Functions
Create And Edit Functions
Declaring Functions
Arguments In Functions
Adding To Paste Function Dialog Box

Public Vs Private Declarations
Function Declarations
Procedure Declarations

Introduction To Array Concept
Array Functions In Excel
Using Arrays In VBA
Working With Ranges
Move And Copy Fixed Or Indefinite Ranges
Determining Next Empty Cell
Determining Types Of Ranges
Returning Information About A Range
Analyzing Cells In A Range
Determining If A Range Is Contained In Another Range
Ranges And Arrays
Sorting An Array
Procedure To Sort

Working With Files
Processing A Series Of Files
Extracting File Information–Name,Path, etc.
Using Relative Sheet References In Custom Functions

Select Case
Using Case Instead of IF
Select Case Constructs

Creating and Designing Forms and Custom Dialog Boxes
VBA Forms vs. Excel Forms
Create a Custom Dialog Box form
Combo Boxes
List Boxes
Check Boxes
Option Buttons
Using Event Handling to Display Forms
User Form Templates
Multi – Page Forms


Prerequisites & Certificates

Course Prerequisite: Required: Solid understanding of all Excel Macros & VBA Level I topics.

Certificates offered

Participants receive with this course: * courseware (notes on all topics covered, along with exercises used during course). * a certificate of completion

Cancellation Policy

Map & Reviews
Computer Help
[ View Provider's Profile ]


This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.

This page has been viewed 486 times.