Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a combo box that a value is chosen from...
If the user chooses the 4th item in the list, if the list refreshes during the subsequent on change actions, how do I tell the combobox to Display that value again? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The fourth item in the list is identified as the ListIndex value for the
control = 3, However if the control is being refreshed then there maybe no guarantee that the list contains the same items or in the same order, if you know they will be then store the ListIndex value before the update and reapply it after. Otherwise if the item is in the list set the control to the stored value not the list index. If the item is not in the control you need to decide what action to take first before deciding on the code to use. -- Regards, Nigel "jayklmno" wrote in message ... I have a combo box that a value is chosen from... If the user chooses the 4th item in the list, if the list refreshes during the subsequent on change actions, how do I tell the combobox to Display that value again? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combo Box vba that works like Forms Menu combo box | Excel Programming | |||
Excel VBA Combo Box Populating dependent on other combo box choices | Excel Programming | |||
Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |