Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with togglebutton that displays jpg | Excel Discussion (Misc queries) | |||
Setting ToggleButton Value | Excel Programming | |||
hide rows with macro/togglebutton | Excel Programming | |||
need help with togglebutton | Excel Programming | |||
2 macros in a Togglebutton? | Excel Programming |