How do I clear data in selected cells automatically

[Guest]

I am writing a program to do mortgage calculations customized to my needs.So
far I have been able to do this with built in functions and some of my own
formulas.

I need to be able to clear the input fields quickly when working with a new
customer.Is there a way to clear designated fields just by setting up an
clicking a drop down box?

thanks in advance for your help.

Jim Train

 

[nrivera]

I not sure if this will work for your problem but you might give it
look. I added a macro to a button to clear all unlocked cells. Yo
might try it with your drop-down list.

The following link to view the macro:
http://www.mrexcel.com/archive2/58900/68299.htm

-nmriver