Goto a specific part of a list

[austenr]

I have a userform with a scroll bar that allows the user to scrool to the row they want. Potentially there will be thousands of rows of data. Is there a way to jump to a specific part of the list say the ones starting with "G"? Thanks

[lucas]

austenr,
I may be wrong but I think you can add a textbox(textbox2 in my example) and use this code on it:


Private Sub TextBox2_Change()
Dim Search As String
Dim n As Long
Dim i As Long
Dim j As Long
Search = Me.TextBox2.Text
n = Len(Me.TextBox2)
j = Me.lstSelection.ListCount - 1
For i = 0 To j
If Left(Me.lstSelection.List(i), n) = Search Then
Me.lstSelection.Selected(i) = True
Exit For
End If
Next
End Sub


lstSelection is the name of your listbox. change those two things to match your listbox and textbox. then when you type the first letter in the search(textbox) it will go there immediatly. Works for me

[austenr]

Thaks that worked great!!

[lucas]

Your Welcome,
Glad it works as well for you as it did for me.
Thats one of many I have pilfered from this forum in the past.
You can mark this one solved then?

[austenr]

yep