ComboBox update

  • Thread starter Thread starter Justin
  • Start date Start date
J

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?
 
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
 
I forgot to mention that I'm using comboboxes in a UserForm, not on the
worksheet itself.
 
I figured out that I can have the worksheet cell = the value of the
combobox in the "change()" event. Problem solved!
 
Back
Top