From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 24,900 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

Start my 1-month free trial Buy for my team

Using list boxes and combo boxes to facilitate forms creation

“

- [Instructor] On this worksheet, we're seeing two different kinds of what are called form controls, a list box and a combo box. You probably wouldn't be using both of these at the same time looking at the same data, but nevertheless, it's worth exploring the values of each, or which one you might consider using here. In the list box, the upper box here, if I click with the mouse, Colorado, I see information off to the left changing. The information that's changing here is ultimately based on formulas, getting data from columns A through C. If I want to go to a different state, if I don't see it in the list here, I'll drag that scroll box to the right up or down as necessary. I'll choose New Hampshire, and we see the changes occurring there as well, too. The combo box is essentially the same thing, but it looks a little different. There's only one state visible at a time. Right now, it happens to be Oregon and we see…

Contents