Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Nigel, et al.
Thanks Nigel for the ideas, but they did not seem to work. I did a search on msoOLEControlObject in this group and came across something Dave Peterson contributed back in 2001. The syntax is a little more complicated but it works. Here are the guts: Sub GetControls() Dim shp As Shape Dim ws As Worksheet, str As String Set ws = Worksheets("Scenario Map") For Each shp In ws.Shapes If shp.Type = msoOLEControlObject Then If TypeOf shp.OLEFormat.Object.Object Is MSForms.Label Then shp.OLEFormat.Object.Object.Caption = "Label Test" End If Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Updating Properties of a Control on a Worksheet | Excel Programming | |||
How to control chart properties from worksheet | Excel Discussion (Misc queries) | |||
How to control chart properties from worksheet | Charts and Charting in Excel | |||
Updating range properties is so sloooow!!! | Excel Programming | |||
Active X not updating properties on Excel Sheet | Excel Programming |