ComboBox update

[Justin]

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?

 

[Peter]

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

 

[Justin]

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

 

[Justin]

I figured out that I can have the worksheet cell = the value of the
combobox in the "change()" event. Problem solved!