macro
 

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,
--
danny

macro
 

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

--
__________________________________
HTH

Bob

"danny" wrote in message
...
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,
--
danny