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

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

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

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