PDA

View Full Version : Solved: VBA -Clearing the dropdown cells



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.

Bob Phillips
07-15-2009, 06:57 AM
Assign this macro to the button


Sub ClickThis()
Activesheet.Range("A1").Value=""
End Sub

Dimitriy
07-15-2009, 07:03 AM
Thank you! That was simpler than I thought it would be.