listview starting from the 120th item

[DJones48]

Is it possible to view listview starting from the 120th item when it initializes. I have a varying listview containing past,present and future transactions. These transactions are sorted into date order. What I would like is for when the listview initialises it starts its view in the middle ie opens up on todays date with past transactions above and future transactions below.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
though I have used this forum many times before this is my first post. I have searched this forum and others for answers, but listview questions and answers are very few<o></o>
<o></o>
thanking you in advance<o></o>

 

[Richard Schollar]

Hi & Welcome to posting to the Board!

Assuming your list is a listbox control on a userform then you can do this by writing some code into the Userform Intialize event:

Private Sub UserForm_Initialize()
With Me.ListBox1
   .List = Sheet1.Range("A1:A200").Value   'amend as required
   .ListIndex = 119   'list indexes are zero based
End With
End Sub