mferrisi
09-21-2010, 08:13 AM
Hi,
I have a listbox with a few hundred items in it. I've set up a textbox
s = TextBox1.Text
1 To Sheets(1).ListBoxes(2).ListCount
If UCase(Sheets(1).ListBoxes(2).List(i)) Like UCase(s & "*") Then
Sheets(1).ListBoxes(2).ListIndex = i
Exit Sub
End If
Next
Here, the item is selected, but the scroll bar doesn't move, so the user still has to scroll down the sheet in order to see the selection. Is there a 'TopIndex" or some similar property that makes this easy to do?
Thanks,
I have a listbox with a few hundred items in it. I've set up a textbox
s = TextBox1.Text
1 To Sheets(1).ListBoxes(2).ListCount
If UCase(Sheets(1).ListBoxes(2).List(i)) Like UCase(s & "*") Then
Sheets(1).ListBoxes(2).ListIndex = i
Exit Sub
End If
Next
Here, the item is selected, but the scroll bar doesn't move, so the user still has to scroll down the sheet in order to see the selection. Is there a 'TopIndex" or some similar property that makes this easy to do?
Thanks,