Excel Help/Question

[MrCodeDude]

In a cell, is there a way I can make it so people have to select from options in a drop down list from a cell?

 

[Colt45]

Not that I am aware of.

 

[Yossarian]

absolutely, read up on the ComboBox option. use VBA for more functionality, it's included w/excel.

 

[z0mb13]

Originally posted by: Yossarian
absolutely, read up on the ComboBox option. use VBA for more functionality, it's included w/excel.

what he said

 

[kranky]

Does this help?

 

[HomeBrewerDude]

yes and its relatively easy.


see kranky's link.


i like to use lists/drop downs in combination with database functions. (e.g., use drop downs to let an end user define search parameters for a report)

 

[Rogue]

And you call yourself MrCodeDude....bah

 

[Grunt03]

after you finish filling in all fields like the items below......
name address phone sex height weight

____ ______ _____ ___ _____ ______
____ ______ _____ ___ _____ ______
____ ______ _____ ___ _____ ______
____ ______ _____ ___ _____ ______
____ ______ _____ ___ _____ ______

Next you will need to select all item's, hit the box between A and I or edit select all
go to data at the top and select filter then auto filter. Now you will see each column
will have a drop down arrow allowing you to choose.......

Hope that this is what you were looking for.