drop down list

G

Guest

Can someone help me with the drop down list. I saw an example on excel help
but it is not working for me. Really different from Access. I have four
choices I would lke to have people choose from.

On-Track
At-Risk
Concerns
Decision Required

Can someone help me with creating the list.
 
G

Guest

Put the four value in a column (say A1 to A4) and name the list e.g. name is
"myname"

Insert==>Name==>Define===>'myname' no quotes))

Then select cell for your drop down list, then do:

Data==>Validation==>Allow->list==>Source "=myname" (no quotes)

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Drop Down choice needs to lead to another drop down menu 1
Linking drop down lists to another list 4
Drop down list and macros? 1
Restrict Choice in Shared WB (drop down alternative)? 0
Drop down list ???? 1
To Link drop-down list 1
Drop-down list with Lookup function? 2

Top