Hi Philip,

Correct. If you want an event to take place with the combo box change then
it is
Private Sub ComboBox1_Change()

As a little further info, if you are unsure if an event is taking place when
you don't want it to then during development, place a Msgbox as the first
line in each event. Use the sub name as the message something like this for
each event:-

Msgbox "Private Sub ComboBox1_Change" has been called.

Simply comment them out with a single quote when you no longer need them.

Regards,

OssieMac


"Philip J Smith" wrote:

Hi

Chip Pearson's notes on these state that these events do not occur when the
value is changed as the result of a calculation.

Is it also true that these events do not occur when the change is as a
result of a selection from a combo-box being changed?

Regards

Phil Smith