Positioning the selected row in a listbox

[Nicola M]

Hi all! Excel 2003.

Here my trouble. I have a Listbox. I add it items and select the proper item
programatically. Unfortunately my selected row is always the last visible
row. I'd like that this selected row (it is the current date) be showed as
the second so I have yesterday as the first visible row and the day after
tomorrow as the third row.
Is there a way to get this?

Thank you in advance for any tips and suggestions.
Nicola M

 

[Bob Umlas, Excel MVP]

Set the listindex to 1 to get the 2nd item (0 gets the first, -1 deselects
all, etc)