Run macro when check box ticked.

[JazzSP8]

Hi All

I've been trying to excute a macro when I tick a Check Box but can't seem to get it to work.

I've been trying to use the Worksheet_Change method, but with no luck. Having taken myself off to look into it I've realised that its probably not working because I'm not pressing the 'Enter' button and therefore Excel isn't seeing the True/False in the cell attached to the check box as a change.

Is there any way I can have my macro run when I tick the box?

Thanks in advance for any help...

Jazz

 

[Andrew Poulsom]

Where is the CheckBox from - Control Toolbox or Forms Toolbar? If the former it has a Click event procedure created by right-click View Code. If the latter you can assign it a macro by right clicking it.

 

[JazzSP8]

D'oh - Can't believe I didn't notice 'Assign Macro'

Thanks for the quick reply!