Courses

Excel User Forms

= Scheduled class    = Guaranteed to run    = Fully booked

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