Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox Update | Excel Programming | |||
Update combobox | Excel Programming | |||
combobox update | Excel Programming | |||
combobox update | Excel Programming | |||
Combobox update | Excel Programming |