Set default values marco

I have a model where there are several user defined entries. The ones I can't seem to get to work are resetting a value from a drop-down menu. When recording the macro it does not acknowledge a selection from the drop-down menu. Due to the complexity of the model I want to add a reset defaults button to reset all the values on a worksheet. If anyone knows how to get a macro to reset a value from a drop-down menu please let me know.

Thanks!

Hi
something like
activesheet.range("B1").clearcontents

--
Regards
Frank Kabel
Frankfurt, Germany


RJ wrote:
I have a model where there are several user defined entries. The
ones I can't seem to get to work are resetting a value from a
drop-down menu. When recording the macro it does not acknowledge a
selection from the drop-down menu. Due to the complexity of the
model I want to add a reset defaults button to reset all the values
on a worksheet. If anyone knows how to get a macro to reset a value
from a drop-down menu please let me know.

Thanks!

What kind of drop-down are you talking about? Are you refererring to a
combobox that has been added to the workbook from one of the toolbars
or are you talking about a cell with a drop-down data validation
added?

Rollin


---
Message posted from http://www.ExcelForum.com/