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.

Please Login or Register  to view this content.