Excel Option Button Blitz

Options buttons are an easy to use interface. They are a little tricky to create and incorporate in your Excel file. This session will remove the mystery and show you how to make the most of these controls. Topics covered include.

Why and when to use option buttons
How to use option buttons
Using more than one set of buttons on a sheet
Formulas that work well with option buttons
Validating option buttons
Sheet protection and option buttons
Range names and option buttons
Worked example - using option buttons with macros

Level: Intermediate
Duration: 1 hour
Price: AU$25

Enrol for $25 AUD

Course Content

Course materials

The session materials

a pdf manual which you can print out and make notes in
Excel file to work through during the session
the completed file to review if you need to

OptionButtons.pdf

416 KB

OptionButtonsBlitz.xlsm

120 KB

OptionButtonsBlitz completed

143 KB

Course Video

Option Button Blitz Session Recording

(1h 08m 48s)
234 MB

Option Button Quiz

Option Button Blitz Quiz

Excel Check Boxes

Learn how to improve the user interface with options buttons.

They work with formulas and macros.

Enrol for AU$25

Excel Option Button Blitz

Learn how to use option buttons (aka radio buttons) to improve the Excel User interface. Version: All Versions Recorded: Jun 2021 Level: Intermediate Duration: 1 hour Price: AU$25

Buy now