ComboBox update
 

Is there a better way to update the worksheet upon making a new
selection in a ComboBox other than changing focus from the combobox to
another object, and then returning the focus to that combobox on a
combobox_change() event?

ComboBox update
 

Depends on which kind of combobox you are using:

If using the one from the forms toolbar then you can use right click
/format control/control tab/linked cell.

This ensures that the cell named always has a copy of what is selected.


A similar facility exists for the control toolbox combo and this is
acessible via the right click/properties/linked cell

ComboBox update
 

I forgot to mention that I'm using comboboxes in a UserForm, not on the
worksheet itself.

Peter wrote:
Depends on which kind of combobox you are using:

If using the one from the forms toolbar then you can use right click
/format control/control tab/linked cell.

This ensures that the cell named always has a copy of what is selected.


A similar facility exists for the control toolbox combo and this is
acessible via the right click/properties/linked cell