AUCKLAND (09) 378-0411       HAMILTON (07) 838-0700       WELLINGTON (04) 472-4830      CHRISTCHURCH (03) 365-5020      |      
Home Courses Excel User Forms


Excel User Forms

Length: 1    Cost: $295 + GST    Version: Excel

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online

Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.

About this Course

By this stage you probably know what you are doing but others may not be so skilled. Lets make things easy for them.


You will need to have done the Excel Objects course and be happy with the concepts covered, or have equivalent experience with VBA and Excel.

At Course Completion

A short and tightly focussed course; we show how to use the tools and create the code for a custom dialog.

Course Outline

Creating a Custom Dialog Box
Starting with a blank canvas

Controls And Their Properties
Some details about the parts of the dialog

Displaying A UserForm
Showing the form on screen

Working With Option Buttons
Only once choice allowed. Which one is it?

Retrieving Values From A Form
Finding out what someone typed

Setting Initial UserForm Values
Giving them some hints to start with

Data Validation
Checking that they typed the right thing

 Print this page