Changing the toggle button setting during another macro i.e., without physically clicking it

[dougmarkham]

Hi Folks,

I have a Toggle button on one of my sheets called: LocationFormat.
It works a treat.

My question is: can I add VBA code to another macro in order to turn off or turn on the Toggle button, i.e. so it automatically changes state when I run another macro?

Kind regards,

Doug.

 

[Jaafar Tribak]

This should do it:

ToggleButton1= Not ToggleButton1

 

[dougmarkham]

Hi Jaafar,

I tried your code:
ToggleButton1= Not ToggleButton1
It's my only toggle button , but this code didn't work and also didn't cause run-time error.

Also, I substituted using my Toggle button name:
LocationFormat = Not LocationFormat

This didn't bring up an error, but didn't turn off the button.
I have more than one toggle button in the workbook.

Any ideas?

Kind regards,

Doug

 

[Jaafar Tribak]

How about ?:

 LocationFormat.Value = Not LocationFormat.Value

 

[dougmarkham]

Hi Jaafar,

Thanks for trying. This causes run-time error 424: no object etc.
In the mean-time, I kept searching and got lucky on a Google search: found this which seems to work

Dim Ctrl As OLEObject
Worksheets("MyWorksheet").OLEObjects("LocationFormat").Object.Value = False

Seems to get around the run-time error issue.

Thanks again for your help!

Kind regards,

Doug.