View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul W Smith Paul W Smith is offline
external usenet poster
 
Posts: 74
Default 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!!!!