How to read the value of a drop-down list on a worksheet in Excel using VBA

Question

According to the title, I have a drop-down list that is already populated. In the button command, I want to read the selected value from this drop-down list, which I will use to write the ADO request.

I did VBA in Access a few years ago, so I have some idea of ​​what I am doing, but using it in Excel is new to me.

As a side question, can someone point me as a reference for the types available in VBA excel or any VBA Excel programming resources?

thank

Answer 1

With ActiveSheet.Shapes("Drop Down 1").ControlFormat
    MsgBox "Index chosen = " & .Value
    MsgBox "Item chosen = " & .List(.Value)
End With