Hi

Can anyone advise on a problem I have with regard to list boxes?

I have a userform which shows a listbox. This listbox is populated when I hit a command button. The problem is that the listbox shows 8 rows of items. When I reach the 9th row, I can't see the last inputted entries. I have linked the listbox to rowsource properties via a named range. To ensure that I capture everything, I have set the range to cover every row (by the way there are 3 columns).

Is there a way to view the last entered data? When I used :

Me.ListBox1.ListIndex = ListBox1.ListCount - 1

it scrolled to the bottom (obviously!)

Maybe .AddItem could be the way here?

Thanks