I have a listbox with 4 columns on a userform in Excel 2003 sp3.
I use a for/next loop to update the list from a sheet that has a named
range.
When I add or delete a line, I update the Excel sheet and then reload
the list into the listbox.
The problem is the only way I see the new data is to scoll to the
bottom of the list and then back to the top to force the listbox
refresh.
I need the line of code to tell the listbox or userform to update
itself.
Any ideas??