Listbox Not Updating Until Module Ends

0

Although I am updating (additem) my listboxes as the code goes through its loop, the listbox does not update until all of the code completes. I thought that Application.Screenupdating=TRUE was the cause so I bracketed a listbox update with a Application.Screenupdating=TRUE and another =FALSE. Still no updating. How can I get the listbox to update immediately following "additem"? Thank you!

Answer
Discuss

Answers

0

ScreenUpdating doesn't affect what happens in the ListBox. The ListBox will not update while it has the focus. Depending upon where your ListBox is (in a user form or on a worksheet) you might use different methods to let it lose focus after each addition.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login