MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

listbox update problem

  Asked By: Keana    Date: Oct 20    Category: MS Office    Views: 825

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

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

I need the line of code to tell the listbox or userform to update

Any ideas??



2 Answers Found

Answer #1    Answered By: Marnia Mian     Answered On: Oct 20

If you are using a rowsource then insert into the appropriate place:

Me.ListBox1.RowSource = "=Used_Locations"

' Obviously change Used_Locations to you named range

Answer #2    Answered By: Ayaz Hashmi     Answered On: Oct 20

I had tried that before but left out the "="

Didn't find what you were looking for? Find more on listbox update problem Or get search suggestion and latest updates.