macro

[danny]

Hi,
Please help me do the following:

I created a drop-down box to display data from cell A20-A25, and I want a
macro (Called ClearData) that will reset that drop-down box to cell A20 when
the macro is ran.

Is this possible,
thx,

 

[Bob Phillips]

Sub Reset()
Range("C5").Value = Range("A20").value
End Sub