From the course: Excel Tips Weekly

Unlock this course with a free trial

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

Create a list box to facilitate selection of data from a list

Create a list box to facilitate selection of data from a list - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Create a list box to facilitate selection of data from a list

“

- [Instructor] As you look at this worksheet, 2 what probably grabs your eye first 3 is that list box over in columns L and M. 4 And right now Colorado is selected. 5 Notice as I move the mouse around, 6 we see the finger pointing here. 7 I'll click California 8 and notice that the information to the left 9 that currently relates to Colorado 10 will change as I click California, the most populous state. 11 And we see its population and its rank. 12 The population is actually based on information 13 we see over in column B. 14 A list box is based on input data 15 and we link that to a cell. 16 For the moment, we're not seeing that. 17 So in this movie, we'll show you how to create a list box 18 and along the way be using the index rank 19 and X lookup functions. 20 So let's create a list box. 21 You can't do this unless you have available on your screen. 22 The developer tab up in the ribbon menu system. 23 If…

Contents