Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box (Yes/No)
Hello,
I'd like to add a "Yes/No" combo box to a spread sheet but have no clue...I'd appreciate any assistance. p.s., I notice that I'm able to choose from two types of combo-boxes..(from the various toolbars)...and I'm able to drag the thing to the worksheet...however, I'm clueless regarding formatting... Thanks Steve |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box (Yes/No)
One way is to add Data Validation directly to the cell (or cells). See
http://www.contextures.com/xlDataVal01.html for details. "Shek5150" wrote: Hello, I'd like to add a "Yes/No" combo box to a spread sheet but have no clue...I'd appreciate any assistance. p.s., I notice that I'm able to choose from two types of combo-boxes..(from the various toolbars)...and I'm able to drag the thing to the worksheet...however, I'm clueless regarding formatting... Thanks Steve |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combo Box (Yes/No)
Thank you BekkiM...that did the trick...
"BekkiM" wrote: One way is to add Data Validation directly to the cell (or cells). See http://www.contextures.com/xlDataVal01.html for details. "Shek5150" wrote: Hello, I'd like to add a "Yes/No" combo box to a spread sheet but have no clue...I'd appreciate any assistance. p.s., I notice that I'm able to choose from two types of combo-boxes..(from the various toolbars)...and I'm able to drag the thing to the worksheet...however, I'm clueless regarding formatting... Thanks Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting A Value from a Combo Box to a Cell?? | Excel Discussion (Misc queries) | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
Dynamic Combo Box | Excel Worksheet Functions | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions |