VBA for Excel Advanced

VBA for Excel Advanced

Cost

£145+VAT

Next Date

Enquire

Duration

One Day

VBA for Excel Advanced

Course Description

This course is designed for users who wish to use the advanced functions of Excel including Forms, Loops and integrating previous knowledge into Form design and Events.nd create personalised mailings to groups of people.

Course Content

Loops

For Next | Do While | Do Until | While Wend

Conditional Logic

If Then | Else If | Nesting iF Statement

VB Functions

Using Excel Functions | IS Functions | U Case

Formats

Setting Formats | Setting Dates

Arrays

Declare Arrays | Populate Arrays | Read an Array | Names vs Arrays

Passing Arguments

One Way | Two Way

Events

What are Events | Choosing Event Triggers | Initialising a Form| Validating a Form | Activating the Form

Forms

Creating a Form | Adding a Form | Multiple Tabs | Text Boxes and Labels | Checkboxes and Radio Buttons | Drop Down Menus |Command Buttons | Run the Form

Workbook

Open Workbook Events | Close Workbook Events

Related courses

VBA for Excel

Microsoft Excel Advanced

Microsoft PowerPoint Advanced

BOOK THIS COURSE

Simply complete the form below and we'll come back to you as soon as possible