Hi

I've noticed some weird behaviour using a Combo box linked to a cell.
(For clarity, this is a Combo from the Control toolbox, not a
data-validation combo or a Forms combo).
(XL2000)

The Worksheet_Change event doesn't fire when a new value is selected in
the combo. Well, I expected this, there's a combo Change event isn't
there? What's odd is that when you select a new value, and then move
away from the cell, so that the cell itself definitely has a new value,
the Worksheet_Change event still doesn't fire.

I've noted posts about the data-validation combo not firing
WOrksheet_Change in XL97 - but its seems this problem applies to
Control Toolbox combos in 2000 as well. I'm not too worried as there's
a workaround (I'm going to use the Combo's events) - anyone else come
across this?

cheers


Seb