View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default Positioning the selected row in a listbox

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

"Nicola M" wrote:

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