Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Updating information in 1 file when it is added to other files | Excel Discussion (Misc queries) | |||
Caption control on shapes | Excel Discussion (Misc queries) | |||
Can a CommandBar Control Caption be Formatted ? | Excel Programming | |||
Toggle change control button face id & caption | Excel Programming | |||
setting the caption in a button control | Excel Programming |