"Conditionally formating" a Form object

[kyjae]

Hi All,

I've been asked to design an expenses claim form in the style of an Excel dashboard and my boss has asked for a specific requirement; a visible / invisible checkbox.

So the attached file hopefully illustrates what is required. Cell C3 requires an input value of either 0 or 1. If it's 0, cell C8 returns the text in F4 and if the value in C3 is 1 then C8 returns the text in F5. Simple enough. However, the tricky bit for me is finding the equivalent of conditional formatting to the form checkbox in cell B8; if the value in C3 is 0 (returning the text in F4) the checkbox needs to be visible. If the vlaue of C3 is set to 1 (returning the text in F5), the checkbox needs to "disappear" or effectively appear completely white so the user cannot check it.

Is there a way of achieving this? Is it possible for the checkbox to "disappear" and prevent it from being checked in the "disappeared" state should the user try to check it by "hit & miss" efforts?

Not having any expertise in this area, I'd be grateful for any pointers to solving this issue.

Many thanks

[Neil_]

Hi,
you need to save your workbook as a macro enabled workbook first, .xlsm format. Right click the tab of your sheet to view code. Paste the following in the code window.

Please Login or Register  to view this content.