Dimitriy
07-15-2009, 06:47 AM
Hey Everyone,
Can someone please advise me on how to "clear" the dropdown list using a macro? For example, in cell A1 I have a data validation dropdown list, consisting of cells B1:B4, with B1 being a blank cell.
I want to be able to with a click of a macro button to go back to B1, so that A1 has no selection in it. Hopefully that makes sense.
Can someone please advise me on how to "clear" the dropdown list using a macro? For example, in cell A1 I have a data validation dropdown list, consisting of cells B1:B4, with B1 being a blank cell.
I want to be able to with a click of a macro button to go back to B1, so that A1 has no selection in it. Hopefully that makes sense.