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!!!!
|