From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,100 courses taught by industry experts.

Create forms using check boxes and option buttons to simplify data entry

Create forms using check boxes and option buttons to simplify data entry - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Create forms using check boxes and option buttons to simplify data entry

“

- [Instructor] On this worksheet, 2 we're seeing two features 3 that are likely to be of great help 4 if you're setting up a form. 5 The round buttons we're seeing in column A 6 are called option buttons, 7 frequently called radio buttons. 8 They're mutually exclusive. 9 We can only click on one of them at a time. 10 Below that are two check boxes. 11 Now those can both be empty 12 or either one can have a check 13 or both can have a check. 14 And the way we set these up is not exactly obvious. 15 We need to use what's called a Developer tab. 16 But look what happens when I change this button 17 to be Non-city. 18 off to the right, 19 the scenario is imagine a municipal college. 20 Standard rate is simply the credit hours 21 times the credit hour rate $2,400. 22 Here's a basic charge. 23 But if you live in state but not in the city, 24 there's a surcharge of 20%. 25 And if you're out of state, 26 there's…

Contents