Logo 
Search:

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: 668
  

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??

Share: 

 

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.




Tagged: