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

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

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

-nmrivera


--
nrivera
------------------------------------------------------------------------
nrivera's Profile: http://www.excelforum.com/member.php...o&userid=23448
View this thread: http://www.excelforum.com/showthread...hreadid=373927