Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / November 2007

Tip: Looking for answers? Try searching our database.

resetting combo box to top line

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
scottgp - 28 Nov 2007 15:13 GMT
Hi,
 We've got two combo boxes (off of the forms toolbar) that we keep in
sync, meaning changing the selection in the first one kicks off a
macro that applies a filter to a range, and copies the result to the
area that is used as the source for the second combo box.  The input
range for the second combo box is fixed to about 100 rows.
 Here's the issue.  If, for example, the tenth row is selected in the
second combo box, and then a new selection is made in the first combo
box causing the second combo box to only have one or two items, it is
still positioned at the tenth "blank" row.  The user has to know to
scroll up in the second combo box to get to the visible choices.  Is
there any way to force the second combo box to the top of the list?
Thanks,
Scott
sebastienm - 28 Nov 2007 17:25 GMT
Hi,

At the end of the code setting the new data list in Combobox2, do
  ''' ... here, code filling up combobox2, then
  Combobox2.ListIndex=0

Signature

Regards,
Sébastien
<http://www.ondemandanalysis.com>

> Hi,
>   We've got two combo boxes (off of the forms toolbar) that we keep in
[quoted text clipped - 10 lines]
> Thanks,
> Scott
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.