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

Courses


Excel User Forms

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

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online
CentreJunJulAugSep
Auckland--
24
----
Hamilton------
27
Christchurch--------
Wellington--
17
----

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

This course is designed for users of VBA within the Excel object model who wish to make a VBA UserForm for use within Excel.

Our aim is to provide you with the necessary skills to achieve this

It is important that you use your new skills as soon as possible on completion of this training course. We encourage you to take your own notes and to review this Course Guide once you are back at your workplace.



Prerequisites

We recommend that students have:

  • Completed our VBA Essential Skills course

And

  • Completed our Excel Objects course

Or

  • Have an equivalent knowledge of Excel and VBA

At Course Completion

This short course is designed to use both tools and code to create custom dialog boxes and forms.

Course Outline


  • Creating a Custom Dialog Box
  • Controls and their Properties
  • Displaying a UserForm
  • Working with Option Buttons
  • Retrieving Values from a Form
  • Setting Initial UserForm Values
  • Data Validation

 Print this page