View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Andreas.Wendzel@googlemail.com is offline
external usenet poster
 
Posts: 1
Default updating caption of added control

Hello,

i use following code to add a togglebutton to the sheet:
Set objOle =
ActiveSheet.OLEObjects.Add(ClassType:="Forms.Toggl eButton.1", _
Left:=intLeft, Top:=intTop, Width:=intWidth, Height:=intHeight)
With objOle
..Object.Caption = "test"
End With

The problem is, that the caption doesn't update until, i click the
Button.
The same problem occurs with CommandButton.
Sometimes it works, but in most cases, this error occur.

Any ideas?
Thanks a lot,

Andreas