View Full Version : VBA Code to select value from Popup dropdown

08-22-2013, 03:16 AM

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.


08-22-2013, 03:39 AM
I'd recommend a VBA book for beginners.

Kenneth Hobs
08-22-2013, 05:51 AM
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.