Calling a Private SUB from SHEET

**satanovsyn** · 01-20-2011, 05:40 AM

Hello,

I need to call this Sub CheckBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
from Module.

Normaly this is not function. "I can´t find Macro: CheckBox1_DblClick"

Please Login or Register  to view this content.

What I need is macro, when I click on button, BackColor of CheckBox is changed from white to red.

Help please

**BigDat6CC** · 01-20-2011, 05:53 AM

Hello

Is it at all possible to change the BackColor of a check box?

**snb** · 01-20-2011, 06:14 AM

Please Login or Register  to view this content.

**romperstomper** · 01-20-2011, 06:14 AM

If you want to run the same code from 2 places, you should put it into a routine in a normal module and then call that routine from both places.

**satanovsyn** · 01-20-2011, 08:52 AM

Originally Posted by snb

Please Login or Register  to view this content.

I know how change color but:
How can I add this macro to button OMG???
Private is not visible in macro list.

Again.
I have Private Sub and I need assign Private sub to my BUTTON !!!