resetting combo box to top line
 

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

resetting combo box to top line
 

Hi,

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

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


"scottgp" wrote:

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