Advanced Worksheet Controls in #Excel using a Checkbox

How to use advanced control structures in Excel in order to limit what and how the user can input values into a worksheet.

This example uses a checkbox to prevent a user from filling out a form - the checkbox automatically triggers changes in formatting and the ability to input values into a cell.

This tutorial illustrates a great combination of a few different techniques that come together to create powerful data control features in the worksheet and, the best part about all of this, is that it does not require a single line of code, no vba or macros!

This trick is great for building powerful forms in Excel, but, the techniques that you will learn, can also be applied to many different scenarios, including when you build master worksheets, search forms in Excel, and much more.

I hope you enjoy this tutorial!

#excel #dataanalysis #exceltutorial

[jajwarehouse]

9:51 A checkbox is not able to change a protected cell. It will give you the error "the cell or chart you're trying to change is on a protected sheet. To make a change, unprotect the sheet." I have been looking for a way around that for a long time without needing to use vba. The same goes for other form controls that link to cells in this manner.

[samc]

Something i can't wrap my head around is _why_ when the formula in Data Validation (05:47) equals the cell in A1, any text is allowed when the box is checked. I imagined the data restriction to allow the word "TRUE" when checked and "FALSE" when unchecked. But the Data Validation is allowing any text to be entered when checked and no text when the box is unchecked. I wonder what your thoughts are.
Thank you for the vid, btw, I followed through completely, my thoughts above are more out of curiosity than actually trying to "solve" something.

[IvanCortinas_ES]

Easy and effective. Thank you very¡ much!!

[holgerrode]

If I have 3 checkboxes, and I only want to allow the user to be able to set one checkbox as true at a time. So, when the user selects a checkbox (set as true) the other two checkboxes need to be set to false. Can this be done with the checkbox function, setting one check box to true, which then sets the other two checkboxes to false?

[ionutcozma]

Hello

Thank you for this tutorial, it is very useful for me. I have a question about this type of rule in the Excel file. If I have to do an excel where I have to use 3 or more checkboxes and these 3 checkboxes have to be accepted by three different people and I want these people to have access to only one box and not the rest of two checkboxes, how can I do this? Do you have a tutorial where I can view this?

Thank you in advance!

[majidramzan]

How you add light to your cursor..please can u tell me about that

[Aelfraed]

All these tutorials are useless to me because they all do something that deletes your undo (ctrl+z) history.