VBA Macro code to clear drop-down menu selection.

Hi there,

Does anybody know whether you can get a macro to clear your selection in a drop-down menu? I've drawn some combo boxes which I use in my spreadsheet to select from a list of options. The first selection in each drop down menu is just blank. Is there anyway of getting your macro to select this blank option (i.e. clear any selection you may have already made)?

Cheers

Hi. Thanks for that. However, the drop-down lists I have aren't data validation lists, they're object boxes that I have drawn instead that pick up the list for the drop-down menu from the spreadsheet. Does anybody know how to get a macro to clear these?