continued combox frustration
 

I have a combo box and the code ties its row sourse to a
series of cells in one of my worksheets. The selection
options are A, B, C, D etc.

I have a change event code that will change another cell
in another sheet if this box changes. If I use the drop
down list and click an option, it changes the linked
cell. If I tab through the box then tab back to it and
type in my option, the linked cell changes. However, if I
tab straight to the combo box (the text in the box
highlights by default) and simply type a new letter in it,
the change event does not trigger for some reason. When I
tab out and come back and do the same thing, it will.
Please help! I need this to work if you tab too it and
overtype the highlighted text????

continued combox frustration
 

Not had this problem. A Change event will only occur if the ComboBox
value actually changes. So tabbing into the box and selecting the same
value does not trigger the event.

Regards
BrianB
=======================================

"scrabtree" wrote in message ...
I have a combo box and the code ties its row sourse to a
series of cells in one of my worksheets. The selection
options are A, B, C, D etc.

I have a change event code that will change another cell
in another sheet if this box changes. If I use the drop
down list and click an option, it changes the linked
cell. If I tab through the box then tab back to it and
type in my option, the linked cell changes. However, if I
tab straight to the combo box (the text in the box
highlights by default) and simply type a new letter in it,
the change event does not trigger for some reason. When I
tab out and come back and do the same thing, it will.
Please help! I need this to work if you tab too it and
overtype the highlighted text????