My new Specification Form uses combo boxes (control form) to select
options for several product models.

The _first_step_ is to select the model with a combo box. Once the
model is selected, the remaining combo boxes provide lists of options
that are appropriate to the model selected. So far so good.

Normally, the user will start with a fresh, blank form to specify a
product. Occassionally, however, the user may specify a product, print
the results, and go on to the next product without reopening the form,
so I provided a button (macro) that clears the form to start a new
product spec.

Unfortunatley, if the user forgets to clear the form and simply changes
the model and proceeds with the new specs, it would be possible to keep
some of the options from the previous model even if they were
incorrect.

IS THERE A WAY TO DETECT WHEN A MODEL SELECTION IS MADE, _FIRST_STEP_
AND RUN THE MACRO THAT CLEARS THE CELLS?

Thanks!

Alex


--
Ingeniero1
------------------------------------------------------------------------
Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
View this thread: http://www.excelforum.com/showthread...hreadid=533424