Learning Excel VBA User Forms

Video Lectures

Displaying all 20 video lectures.
Lecture 1
Drawing Forms
Play Video
Drawing Forms
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/drawing-fo...

http://www.wiseowl.co.uk - Part 1 of this Excel VBA User Forms Tutorial explains how to draw forms and controls. You'll learn how to arrange objects neatly and see a variety of formatting options for basic text boxes, labels and command buttons.
Lecture 2
Running and Navigating Forms
Play Video
Running and Navigating Forms
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/running-fo...

http://www.wiseowl.co.uk - Once you've drawn a form you'll need some way to display it to your users. This part of the series explains how to run a form using buttons on a worksheet and shows you how to navigate through a form by setting the tab order of controls and creating accelerator keys.
Lecture 3
Adding Code to a Form
Play Video
Adding Code to a Form
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/adding-cod...

http://www.wiseowl.co.uk - After you've made your form look beautiful you'll want it to actually do something useful! This part of the series explains how to add code to the events of the form and its controls to make it work. You'll learn how to refer to the form and objects on it, how to change their properties and how to make the form respond to the user's actions.
Lecture 4
Validating Controls
Play Video
Validating Controls
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/validating...

http://www.wiseowl.co.uk - Validation is all about making sure a user has entered sensible values in a control. This video shows you how to use the before- and afterupdate events of a textbox to prevent a user continuing when they've entered invalid data. You'll learn how to check if a value is a number or a date and how to modify the properties of controls at runtime to indicate that there's a problem.
Lecture 5
Validating Forms
Play Video
Validating Forms
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/validating...

http://www.wiseowl.co.uk - Another aspect of validation is checking that every control on a form has been filled in. This video explains how to loop over the controls collection to check if every textbox has been completed.
Lecture 6
ComboBox Controls
Play Video
ComboBox Controls
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/combobox-c...

http://www.wiseowl.co.uk - A ComboBox allows you to create a drop down list on a form, which means that you can provide users with a limited list of choices. This video explains how comboboxes work!
Lecture 7
ListBox Controls
Play Video
ListBox Controls
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/listbox-co...

http://www.wiseowl.co.uk - A ListBox is similar to a ComboBox but with the added advantage that you can select multiple items! This video explains how to work with listboxes on your form.
Lecture 8
Option Buttons
Play Video
Option Buttons
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/option-but...

http://www.wiseowl.co.uk - Option Buttons are useful for providing a set of mutually exclusive options on a form. This video explains how to create groups of option buttons and test which option has been selected.
Lecture 9
Spin Buttons
Play Video
Spin Buttons
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/spin-butto...

http://www.wiseowl.co.uk - Spin Buttons, or Spinners, provide a convenient way to increase and decrease a numeric value. This video explains how spin buttons work, including how to synchronise a spin button with a textbox.
Lecture 10
Scroll Bar Controls
Play Video
Scroll Bar Controls
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/scroll-bar...

http://www.wiseowl.co.uk - A Scroll Bar is like the big brother of a Spin Button, allowing you to set a numeric value by clicking and dragging a bar. This video shows you how to use a scroll bar to control both a numeric value and a date.
Lecture 11
Check Boxes
Play Video
Check Boxes
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/check-boxe...

http://www.wiseowl.co.uk - A Check Box is a simple control which allows the user to indicate an option by checking a box! This video explains how to use check boxes, including how to use a triple-state check box to determine if the user has actually selected an option.
Lecture 12
Toggle Buttons
Play Video
Toggle Buttons
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/toggle-but...

http://www.wiseowl.co.uk - A Toggle Button is functionally identical to a Check Box, although cosmetically it's quite different. This short video provides a quick overview of how toggle buttons work.
Lecture 13
Image Controls
Play Video
Image Controls
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/toggle-but...

http://www.wiseowl.co.uk - Image Controls allow you to display pictures on your forms. This video shows you how to allow a user to select the image that's displayed, including how to use a File Picker dialog box to control which types of image files they can select.
Lecture 14
Multi Page Controls
Play Video
Multi Page Controls
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/multipage....

http://www.wiseowl.co.uk - A Multi Page control is perfect for organising lots of controls into discrete categories to make your forms neat and tidy. This video explains how to work with multi page controls, including how to loop over the pages collection for quickly validating your form.
Lecture 15
Tab Strip Controls
Play Video
Tab Strip Controls
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/tabstrip.h...

http://www.wiseowl.co.uk - A Tab Strip looks similar to a Multi Page control although it behaves very differently. This video explains the slightly odd way in which tab strips work, including how to loop over the tabs collection.
Lecture 16
Playing YouTube Videos
Play Video
Playing YouTube Videos
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/playing-yo...

http://www.wiseowl.co.uk - Playing videos in a VBA user form is perhaps a little frivolous but it makes for a fun video! You'll learn how to add extra controls to the toolbox, how to use the Shockwave Flash Object and a little about how to use VBA's string functions to manipulate YouTube's video URLs.
Lecture 17
Editing Data
Play Video
Editing Data
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/editing-da...

http://www.wiseowl.co.uk - User forms aren't just for data entry; you can use them to edit and delete data too! This video explains how to create a form which allows the user to browse a set of records held in a worksheet and to edit and delete that data using the form. Along the way, you'll learn about a couple of advanced programming techniques such as declaring Enumerations and Property statements.
Lecture 18
Installing the Date Time Picker and Month View Controls
Play Video
Installing the Date Time Picker and Month View Controls
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/installing...

http://www.wiseowl.co.uk - Entering dates into a text box is awkward, difficult to validate and dull. Selecting dates from a dedicated Date Time Picker or Calendar solves all of these problems at once! This video explains how to install and register the Microsoft Date and Time Picker Control and the Microsoft Month View Control and explains how to add them to your User Form Control Toolbox. The video also briefly explains how to use these controls in your forms.
Lecture 19
Using the RefEdit Control
Play Video
Using the RefEdit Control
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

By Andrew Gould
Download files here http://www.wiseowl.co.uk/videos/excelvbauserforms/refedit-co...

http://www.wiseowl.co.uk - The RefEdit control provides you with a way to select cells from the comfort of a user form in Excel. This video explains how to make the RefEdit control available, how to use it to select cells and how to use the value it returns to manipulate the cells you've selected. The video also includes a section on a few potential issues with the RefEdit control and shows a couple of alternative techniques using the Application.InputBox method.
Lecture 20
Progress Bars
Play Video
Progress Bars
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link http://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

You can download the required files from this page http://www.wiseowl.co.uk/videos/excelvbauserforms/progress-b...

By Andrew Gould

http://www.wiseowl.co.uk - This video explains the basics of using progress bar controls on your VBA user forms. You'll see how to add the control to the toolbox and how to draw and edit progress bars on a form. Most importantly, you'll learn how to update the value of a progress bar at run time so that it indicates progress through a procedure.