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.
Why Create Functions
Create And Edit Functions
Arguments In Functions
Adding To Paste Function Dialog Box
Public Vs Private 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
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
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.
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
[ 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 447 times.