ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combo Box (Yes/No) (https://www.excelbanter.com/excel-discussion-misc-queries/67669-combo-box-yes-no.html)

Shek5150

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


BekkiM

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


Shek5150

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



All times are GMT +1. The time now is 05:40 AM.

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