Using object properties that are not specified in Object Browser

Question

I studied the basic structure of object properties and methods in VBA a bit more. I just read that all the properties and methods for each object are listed in the "Object Browser" in the developer window.

The reason I was asked to take a look at this was because I used a method that was not specified in the object browser. I used:

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

This allowed me to then use .List to change the form. However .ControlFormat is not a property / method specified in the Object Browser.

Can anyone explain this?

Answer 1

- , "Shapes", , "Shape", ?

---

:

Shapes Shape, Shapes , Collection. Shape, Shape

Answer 2

, , ( )

intellisense.

.

Sub Sample()
    Dim ws As Worksheet
    Dim Shp As Shape

    Set ws = Sheets("Front face")
    Set Shp = ws.Shapes("Drop Down 12")
End Sub

, Shp., .ControlFormat.

.Range , , Activesheet.. intellisense .