Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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