Learning Excel VBA User Forms
Video Lectures
Displaying all 20 video lectures.
Lecture 1![]() 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![]() 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![]() 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![]() 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![]() 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![]() 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![]() 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![]() 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![]() 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![]() 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![]() 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![]() 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![]() 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![]() 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![]() 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![]() 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![]() 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![]() 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![]() 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![]() 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. |