View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dan E[_2_] Dan E[_2_] is offline
external usenet poster
 
Posts: 102
Default pulldown boxes

"Data" - "Validation"
Under Allow pick "List"
In the Source Type "Yes, No" (without quotes)
Uncheck the "Ignore Blank" checkbox
Hit OK

You can also populate it with a list from your sheet by entering a range in
the "Source" field.

Dan E

"david" wrote in message
...
I was wondering if it was possible to make a pulldown in a
cell. So, that I could make them select from the pulldown
menu choices. For example in a certain cell, I just want
them to select yes or no.

Thanks for you help,
David