Using object properties that aren't listed in Object Browser

Question

I've been looking into the underlying structure of object properties and methods in VBA a bit more. I've just read that all properties and methods for each object is listed in the "Object Browser" in the developer box.

The reason why I was prompted to look at this was that I used a method that wasn't listed in the Object Browser. I used:

Sheets("Front face").Shapes("Drop Down 12").ControlFormat

This allowed me to then use .List to change the Shape. However .ControlFormat isn't a property/method listed in Object Browser.

Can anyone explain this?

Answer 1

It appears in mine - perhaps you're looking for "Shapes" which is a collection, as opposed to "Shape" which is the actual object?

---

Detail:

Shapes is a collection of Shape objects - therefore Shapes has properties and methods that relate to a Collection object. Each item in that collection is a Shape object which has the properties and methods of a Shape