VBA Code to select value from Popup dropdown

[rockybalboa]

Hi,

I have an excel sheet which when opened gives a Popup window with four options to select from the drop down list. I need a code to select a particular value from the popup dropdown list and select ok. Do let me know if you need more info.

Thanks..

[snb]

I'd recommend a VBA book for beginners.

[Kenneth Hobs]

Dialogs are made for the user. If that is the case, then code the macro to skip it since you are the user. Otherwise, post the workbook.