Thread: How to identify the name of a dropdown box?

Hi, there
I have a spreadsheet with a dropdown boxe in there. How do I identify the name of it to be able to use some VBA code to set the the dropdown box to a certain value when I click a button. Please see the attached file to have a better understanding what I would like to do. Thanks a lot.

Regards,
Lily

You can select the dropdown control and see the name in the Name box, next to the formula bar.

Sub InitialAll_Click()
' Clear all Green Guide sheet

' select first item in list
    ActiveSheet.Shapes("Drop Down 1").ControlFormat.Value = 1
'
End Sub