How to Add a Check Box Control to an Excel Form

At first glance, adding a Check Box Control (Yes / No, True / False, etc.) to an Excel Form seems easy to do. And it is, once you know where the "got ' cha" steps are and what to do to avoid these traps!

I worked hard to make this expanation as easy as possible for you - my viewers - to understand. I feel that this is an Excel concept that is easier to understand when you "see it" being created rather than "reading about" how to do it.

Please let me know with your comments: "True or False," did I make it easy for you to understand how to add a Check Box Control to an Excel Form?

Best,

Danny Rocks
www.thecompanyrocks.com

Category:

Education

Tags:

• MS
• Excel
• Form
• Controls
• Check
• Box
• Control
• Formulas
• Functions
• Conditional
• Formatting
• Lessons
• Tutorial
• Howto

[UNBORNMAN1]

Dear Mr.Rocks

you are expert in excel ,thank you very much for your example on youtube

my harm regards

kamil.karkafi@hotmail.com

[DannyRocksExcels]

@UNBORNMAN1

My pleasure. Thank you for your kind words.

Danny Rocks

The Company Rocks

[usausb]

Thanks for this great tut :)

But how do I make the check box inside a cell ? so I can copy that cell to a bunch of cells?

[DannyRocksExcels]

@usausb

Sorry for the delay in responding - somehow your message got lost in my inbox.

The Check Box is "Drawn." Now, you can position it so that it "appears" to be inside a cell.For example, remove the label 'Check Box" and then Narrow the Width of the Column.

I hope that this helps you to understand Check Boxes.

Danny Rocks

The Company Rocks

[radiogiraffe]

Is there a way to make a single checkbox check and uncheck multiple other checkboxes?

[DannyRocksExcels]

@radiogiraffe

Sorry for the delay - You message got lost in my Inbox.

The key to making this work - as you describe - is the "linked cell" concept. So, the "linked cell" for your 1st check box contains a value or a formula. Your 2nd and additional check boxes contain formulas that reference the value in your 1st linked cell.

Does that make sense to you?

Email me with an example and I will see if I can help.

Danny Rocks

The Company Rocks

[DannyRocksExcels]

@matiur70

The 3rd example uses Conditional Formatting for the range of numeric values in Column C. With Conditional formatting, the formatting is only applied if the answer to "the Condition" is TRUE. I used 2 "Rules" with Formulas for the Condition =AND(cell with check box is "TRUE", Cell Value is >= the value in another cell. In this case I refer to a cell with the 5th Higest Value in the Range. The 2nd Rule refers to a cell with the 5th lowest value in the range.

Danny Rocks

[matiur70]

I am a laymam in Excel, but fully understood first two example.

Please let me know how you did the third example.

Many thank in advance.

Matiur

[DannyRocksExcels]

@Grrymjo

Well, I am sorry that my intonation is annoying to you. Thank you for the compliment about the information that I provide.

Sincerely,

Danny Rocks

The Company Rocks

[Grrymjo]

@DannyRocksExcels Actually, as I am not a native English speaker I find your intonation and a way of speaking extremely annoying.However, you provide valuable information in the form which is easy to understand, so I just get on with it.