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

It would seem that you are already doing that to populate the choices for the
other comboboxes?

If not, then use the click event for the model.



--
Regards,
Tom Ogilvy


"Ingeniero1" wrote:


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

Tom, you said-
-"It would seem that you are already doing that to populate the choices
for the other comboboxes?"-

You are correct IF the user clears all the combo boxes between models
before filling them.
But if they are not cleared first, it is possible to miss one and leave
it with the previous information.
What I am trying to learn how to do is to make the clearing of the
boxes a must or make it happen automatically.

-"If not, then use the click event for the model."-
Could you expand on this?

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

In the last statement It should have been use the click event for the
combobox where the user selects a new model or perhaps a new product.

--
Regards,
Tom Ogilvy


"Ingeniero1" wrote:


Tom, you said-
-"It would seem that you are already doing that to populate the choices
for the other comboboxes?"-

You are correct IF the user clears all the combo boxes between models
before filling them.
But if they are not cleared first, it is possible to miss one and leave
it with the previous information.
What I am trying to learn how to do is to make the clearing of the
boxes a must or make it happen automatically.

-"If not, then use the click event for the model."-
Could you expand on this?

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