Solved: VBA -Clearing the dropdown cells

[Dimitriy]

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]

Assign this macro to the button

[vba]
Sub ClickThis()
Activesheet.Range("A1").Value=""
End Sub
[/vba]

[Dimitriy]

Thank you! That was simpler than I thought it would be.