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 list boxes and combo boxes to facilitate forms creation

Using list boxes and combo boxes to facilitate forms creation - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Using list boxes and combo boxes to facilitate forms creation

- [Instructor] In this worksheet are two different examples 2 of what we call form controls. 3 We've got a list box and a combo box. 4 These are very similar in nature 5 and you can use them in a variety of ways. 6 And you've probably seen something like this on the internet 7 in filling out a form. 8 If I choose California here, or Connecticut or Colorado, 9 it's pretty easy. 10 If I don't see the state I need, 11 I can certainly scroll up and down, 12 make the choice that way. 13 There are arrows, top and bottom here, I can use as well. 14 Make a choice that way. 15 Notice as I do this, cell A3 has changed. 16 Now, these list boxes are tied to or linked to a cell, 17 in this case A3. 18 They're also linked to an input range, 19 in this case it's column F. 20 So think of situations where you might 21 want to allow people to pick a name from a list, 22 and then based on that choice do something with that choice. 23 In…

Contents