Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 58
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 735
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo Box vba that works like Forms Menu combo box Hector Fernandez Excel Programming 4 December 12th 06 08:30 PM
Excel VBA Combo Box Populating dependent on other combo box choices ikabodred Excel Programming 1 March 15th 06 03:16 PM
Filtered list for Combo Box ListFillRange - Nested Combo Boxes DoctorG Excel Programming 3 February 23rd 06 12:15 PM
"Combo Box - getting control combo box to stick in place in worksh ajr Excel Discussion (Misc queries) 1 February 16th 05 02:05 AM
"Combo Box - getting control combo box to stick in place in worksh ajr Excel Discussion (Misc queries) 0 February 15th 05 07:45 PM


All times are GMT +1. The time now is 02:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"