Format check box to shade as default when clicked

[dbutcher]

I have a worksheet that has several checkboxes in it. I want to have the check box automatically color in when clicked INSTEAD of it being checked. Presently I have to click the check box then go into the format control and change the control tab - value tab to Mixed.
Is the a way to have this option instead of the default check mark?

[Andy Pope]

Assuming you are using the Forms checkbox control you can use this in your Assign macro code.

Please Login or Register  to view this content.

[dbutcher]

Yahoo thank you very much....