Wise Owl: Microsoft computer training videos (page 1 of 10)

Showing videos 1-20 (out of 197)

Excel VBA Forms Pt 17 - Editing Data

Posted by Andrew Gould on 18 April 2016

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.

Excel VBA Forms Pt 16 - Playing YouTube Videos

Posted by Andrew Gould on 04 April 2016

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.

Excel VBA Forms Pt 15 - Tab Strip Controls

Posted by Andrew Gould on 31 March 2016

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.

Excel VBA Forms Pt 14 - Multi Page Controls

Posted by Andrew Gould on 31 March 2016

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.

Excel VBA Forms Pt 13 - Image Controls

Posted by Andrew Gould on 31 March 2016

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.

Excel VBA Forms Pt 12 - Toggle Buttons

Posted by Andrew Gould on 31 March 2016

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.

Excel VBA Forms Pt 11 - Check Boxes

Posted by Andrew Gould on 31 March 2016

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.

Excel VBA Forms Pt 10 - Scroll Bar Controls

Posted by Andrew Gould on 31 March 2016

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.

Excel VBA Forms Pt 9 - Spin Buttons

Posted by Andrew Gould on 31 March 2016

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.

Excel VBA Forms Pt 8 - Option Buttons

Posted by Andrew Gould on 31 March 2016

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.

Excel VBA Forms Pt 7 - ListBox Controls

Posted by Andrew Gould on 31 March 2016

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.

Excel VBA Forms Pt 6 - ComboBox Controls

Posted by Andrew Gould on 31 March 2016

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!

Excel VBA Forms Pt 5 - Validating Forms

Posted by Andrew Gould on 31 March 2016

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.

Excel VBA Forms Pt 4 - Validating Controls

Posted by Andrew Gould on 31 March 2016

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.

Excel VBA Forms Pt 3 - Adding Code to Forms

Posted by Andrew Gould on 31 March 2016

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.

Excel VBA Forms Pt 2 - Running and Navigating Forms

Posted by Andrew Gould on 31 March 2016

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.

Excel VBA Forms Pt 1 - Drawing Forms

Posted by Andrew Gould on 31 March 2016

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.

Excel VBA - Data Labels in Scatter Charts

Posted by Andrew Gould on 27 November 2015

Labelling data points in a scatter chart in Excel 2010 or earlier is much more limited than in later versions of Excel. This video explains how to use VBA to label the points with any value you like using simple looping techniques. You'll learn how to label the points in a single chart, multiple charts and multiple data series in a chart.

Excel VBA - Save as PDF

Posted by Andrew Gould on 26 November 2015

This video explains how to use the ExportAsFixedFormat method to save various elements of an Excel file as a PDF document. You can apply this technique to the entire workbook, single worksheets and charts and even to a specific range of cells.

Excel VBA - Disable Screen Updates

Posted by Andrew Gould on 26 November 2015

You can give your VBA code a quick performance boost by simply disabling screen updates while your code runs. This video explains how to achieve that, as well as how to create a basic timer system to test the results.