From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Using option buttons, group boxes, and checkboxes to facilitate forms creation

Using option buttons, group boxes, and checkboxes to facilitate forms creation - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Using option buttons, group boxes, and checkboxes to facilitate forms creation

- [Instructor] In this worksheet are different kinds 2 of what are called form controls. 3 We can use these for setting up forms. 4 We can use them for a variety of applications. 5 They're appealing because users don't have to do any typing, 6 usually it's just a selection. 7 What we do with them can involve other formulas. 8 In the example we're seeing here 9 where we have option buttons in a group box, 10 we see different choices here. 11 They're buttons, so-called radio buttons 12 because we cannot choose any more than one at a time. 13 They're mutually exclusive. 14 As I check MS, MA, et cetera here, 15 a few things on the screen are going to change. 16 Keep your eye on cell A3. 17 Also look over in column E. 18 Things change and you can see what's happening here. 19 Can't see the form is just yet. 20 Form controls are typically linked with cells, 21 and we can then take that information and look up 22 and find other…

Contents