How get a list of OLEFormat.Object properties

G

Guest

I've figured out how to add text boxes, labels, combo boxes etc.

I've spent the last two hours trying to find here and in google, where to
get a list of properties for these objects and the proper drill down to
access them.

I manually added a label, then right clicked and accessed properties. I can
see see the properties, however they don't seem to be logically accessible.

I can access the "Caption" property but not the "font" property. See below.

Set shp =
app.ActiveWindow.Selection.SlideRange.Shapes.AddOLEObject(Left:=dblLeft,
Top:=dbltop, Width:=dblWidth, Height:=dblheight, ClassName:="Forms.Label.1",
Link:=msoFalse)

With shp.OLEFormat.Object
.Caption = strtext
.Font = "Arial"
End With

NOTE: the caption property which is on the same level as Font property
works. It's accessible in the code above. What on earth is going on here and
I guess the real question is where do I find the heirarchy of the properties
so I can access them and change them as needed?

Thanks
 
S

Steve Rindsberg

Matthewmark said:
I've figured out how to add text boxes, labels, combo boxes etc.

I've spent the last two hours trying to find here and in google, where to
get a list of properties for these objects and the proper drill down to
access them.

I manually added a label, then right clicked and accessed properties. I can
see see the properties, however they don't seem to be logically accessible.

I can access the "Caption" property but not the "font" property. See below.

Set shp =
app.ActiveWindow.Selection.SlideRange.Shapes.AddOLEObject(Left:=dblLeft,
Top:=dbltop, Width:=dblWidth, Height:=dblheight, ClassName:="Forms.Label.1",
Link:=msoFalse)

With shp.OLEFormat.Object
.Caption = strtext
.Font = "Arial"
End With

This should do it:

..Font.Name = "Arial"

How you're supposed to figure that out escapes me, though.
Object Brower should help, though.
Look up Checkbox
Click Font in "members of checkbox"
At the bottom it says Property Font as NewFont
Click NewFont to see the properties available for your use.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top