change event/after update event??
 

I have a combo box with the rowsource tied to a range in a
worksheet. The selections are sinlge letters (A, B, C
etc.).

I have a change event program recorded so that a cell in a
worksheet will change when the combo box changes.
However, when I activate the user form and tab to the
combo box in question and type in a letter the cell value
doesn't change. If I use the drop down box, it will. ???

The same problem persists even if I change this to an
After update event???

SDC

change event/after update event??
 

Try setting the controlsource to the cell in question.

The change should occur automatically on exiting the combo box.

--
sb
"scrabtree23" wrote in message
...
I have a combo box with the rowsource tied to a range in a
worksheet. The selections are sinlge letters (A, B, C
etc.).

I have a change event program recorded so that a cell in a
worksheet will change when the combo box changes.
However, when I activate the user form and tab to the
combo box in question and type in a letter the cell value
doesn't change. If I use the drop down box, it will. ???

The same problem persists even if I change this to an
After update event???

SDC