Join Dennis Taylor for an in-depth discussion in this video Using list boxes and combo boxes to facilitate forms creation, part of Excel Tips Weekly.
- In this worksheet are two different examples…of what we call form controls.…We've got a List Box and a Combo Box.…These are very similar in nature,…and you can use them in a variety of ways.…You've probably seen something like this…on the internet in filling out a form.…If I choose California here, or Connecticut,…or Colorado, it's pretty easy.…If I don't see the state I need,…I can certainly scroll up and down,…make the choice that way.…There are arrows, top and bottom here,…that I can use as well.…Make a choice…that way.…
Notice as I do this, cell A3 has changed.…Now, these List Boxes are tied to,…or linked to, a cell, in this case A3.…They're also linked to an input range,…in this case it's column F.…So, think of situations where you might want to…allow people to pick a name from a list,…and then, based on that choice,…do something with that choice.…In other words, this is six for Colorado.…Can we somehow use that information…and go pick up the population…that we see off to the right?…Certainly could.…
These lists, by the way, the Source Lists…
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.