Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ToggleButton Capton
What is the correct way to reference a ToggleButtom from a code module?
I can write code to reference and change the caption property from within the worksheet object, but cannot seem to find the right way to reference the control from a code module. From worksheets: TobbleButton1.capton = "New" From a code module: Activesheet.shapes("ToggleButton1").select works, but Activesheet.shapes("ToggleButton1").capton = "New" does not!!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ToggleButton Capton
You possibly misspelt caption, same as in your post?
capton is not a recognised command, so it will not work, but should also result in a runtime error. -- HTH Kassie Replace xxx with hotmail "Paul W Smith" wrote: What is the correct way to reference a ToggleButtom from a code module? I can write code to reference and change the caption property from within the worksheet object, but cannot seem to find the right way to reference the control from a code module. From worksheets: TobbleButton1.capton = "New" From a code module: Activesheet.shapes("ToggleButton1").select works, but Activesheet.shapes("ToggleButton1").capton = "New" does not!!!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ToggleButton Capton
Hi Paul,
ActiveSheet.ToggleButton1.Caption = "My New Caption" -- Regards, OssieMac "Paul W Smith" wrote: What is the correct way to reference a ToggleButtom from a code module? I can write code to reference and change the caption property from within the worksheet object, but cannot seem to find the right way to reference the control from a code module. From worksheets: TobbleButton1.capton = "New" From a code module: Activesheet.shapes("ToggleButton1").select works, but Activesheet.shapes("ToggleButton1").capton = "New" does not!!!! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ToggleButton Capton
Try ActiveSheet.ToggleButton1.Caption
If this post helps click Yes --------------- Jacob Skaria "Paul W Smith" wrote: What is the correct way to reference a ToggleButtom from a code module? I can write code to reference and change the caption property from within the worksheet object, but cannot seem to find the right way to reference the control from a code module. From worksheets: TobbleButton1.capton = "New" From a code module: Activesheet.shapes("ToggleButton1").select works, but Activesheet.shapes("ToggleButton1").capton = "New" does not!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
togglebutton to act like optionbutton | Excel Programming | |||
Togglebutton | Excel Programming | |||
Togglebutton | Excel Programming | |||
Help with togglebutton that displays jpg | Excel Discussion (Misc queries) | |||
need help with togglebutton | Excel Programming |