ToggleButton Value in a macro
 

I can use this code when using a Private Sub ToggleButton1_Click().

Me.ToggleButton1.Value = False

However, I'm trying to use this in a standard Sub routine. When attempting
it that way, it gives me an error.

How do I use this in a standard Sub routing?

Thanks,
Paul

ToggleButton Value in a macro
 

in a sheet module, me refers to that sheet. In a general module, you would
have to specify the sheet that contains the toggle

Worksheets("Sheet1").ToggleButton1.Value = False

--
Regards,
Tom Ogilvy


"PCLIVE" <pclive(remove wrote in message
...
I can use this code when using a Private Sub ToggleButton1_Click().

Me.ToggleButton1.Value = False

However, I'm trying to use this in a standard Sub routine. When
attempting it that way, it gives me an error.

How do I use this in a standard Sub routing?

Thanks,
Paul

ToggleButton Value in a macro
 

Thanks Tom,

I thought I had tried using the 'ActiveSheet' method, but I guess not.
Thanks for clearing up the usage of Me.
Works great now.

Thanks again.
Paul

"Tom Ogilvy" wrote in message
...
in a sheet module, me refers to that sheet. In a general module, you
would have to specify the sheet that contains the toggle

Worksheets("Sheet1").ToggleButton1.Value = False

--
Regards,
Tom Ogilvy


"PCLIVE" <pclive(remove wrote in message
...
I can use this code when using a Private Sub ToggleButton1_Click().

Me.ToggleButton1.Value = False

However, I'm trying to use this in a standard Sub routine. When
attempting it that way, it gives me an error.

How do I use this in a standard Sub routing?

Thanks,
Paul