How to Add a Check Box Control to an Excel Form

[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

[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]

@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

[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

[TheKenji0909]

Great Lessons.I understand it.

[DannyRocksExcels]

@TheKenji0909

Thank you very much! I am pleased that I helped you to understand how to do this,

Sincerely,

Danny Rocks

The Company Rocks

[Asleeplesknight]

Hey... Danny... great job. I find your demeanor and presentation skills to be very helpful. Many online tutorials have plenty of substance, but the instructor lacks the requisite communications skills to effectively and efficiently get their message across. I appreciate your efforts here. Thank you.

[DannyRocksExcels]

@Asleeplesknight

Thank you so much. I am very pleased that you enjoy my video lessons.

In my first career - in my early 20's - I was a professional musician specializing in Broadway musical productions. It was there that I learned the importance of speech delivery, staging and pacing. It was imperative to keep the audience "engaged" with the production.

The same principles apply today - even more so. It is so easy to lose your audience to the "back button" in a web browser.

Thanks!

[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.

[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

[northwest24]

Is there option when we check the box to shows FALSE ?? and when we uncheck to show TRUE ?? is that posible.. i need for test

[DannyRocksExcels]

@northwest24

The "Logic" for a Check Box is "Checked for Statement is TRUE"; "Unchecked or Cleared for Statement is FALSE."

The only way - that I see - to get arround this would be to change the "Text Label" next to the Checkbox - for example, "Check if NOT attending the event." In this case, the check box continues to return the "Statement is True" - Yes, It is true - I am NOT attending the event.

I hope that this helps you for your test.

Danny Rocks

The Company Rocks