select from a list

[NewTooExcel]

How do I create a list for my form where I can go to a cell and click a down arrow to see the contents of the list then select a item on the list to be displayed in that cell?

 

[Oaktree]

Select the cell (where your dropdown will be) and go to data --> validation, choose to allow list where the source is the range of input values, and click OK.

 

[NewTooExcel]

Can the list be on another worksheet?

Can the list be on another worksheet?

 

[Oaktree]

Yes, but you have to assign it a name first.

To create a named range, just select your list and type a name for it in the name box (or, go to insert --> name --> define).

Then, use =my_list (or whatever your list's name is) as the source of your list in data --> validation.

 

[NewTooExcel]

Great that works

Great that works!!!!! :wink:


Thanks