combobox change 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. ???

SDC

combobox change event
 

-----Original 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. ???

SDC
.

Does the After_Update event work. I have found this better
to use sometimes.

combobox change event
 

No...that didn't work either. This is strange for all the
other combo boxes work like a charm?



-----Original Message-----

-----Original 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. ???

SDC
.

Does the After_Update event work. I have found this
better
to use sometimes.


.

combobox change event
 

Have you tried to set the ControlSource to the cell in question?

The cell should automatically reflect the combobox when you exit the box.

--
sb
"scrabtree23" wrote in message
...
No...that didn't work either. This is strange for all the
other combo boxes work like a charm?



-----Original Message-----

-----Original 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. ???

SDC
.

Does the After_Update event work. I have found this
better
to use sometimes.


.