ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   pulldown boxes (https://www.excelbanter.com/excel-programming/272614-re-pulldown-boxes.html)

Dan E[_2_]

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





All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com