ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combo box help (https://www.excelbanter.com/excel-programming/404387-combo-box-help.html)

jayklmno

Combo box help
 
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?

Nigel[_2_]

Combo box help
 
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?




All times are GMT +1. The time now is 07:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com