![]() |
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? |
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