Check Box - Forms

1. When using the check box from "Forms" the "move and size with cells" is greyed out (found in format controls - properties)
2. When using the check box from "Control Toolbox" this is not greyed out (found in format controls - properties)

I require the tick option on the check box BUT also require the check box to be moved and sized with cells. I also assign a macro to this check box. Does someone have a work around for my problem as I've been pulling my hair out to try & acheive this with no luck???

Hello SJG,

You can easily assign your macro to the Control Toolbox Checkbox.

At Design Time when you place the CheckBox on the Worksheet
1. Right Click the CheckBox
2. Select "View Code" from the pop up menu
3. You will now be in the Visual Basic Editor, editing the Click Event for the CheckBox
4. Type in the following line, replace MyMacro with the name of your Macro. Don't place the name in quotes.
5. Call MyMacro
6. Press ALT+Tab to switch back to Excel

Sincerely,
Leith Ross