jeff_the_creator
New Member
- Joined
- Apr 12, 2016
- Messages
- 1
So i have listboxes on a userform that display status of items at any given time based on data in an excel sheet(s) behind the userform. I can get all of the listboxes to populate/show status but to update these listboxes with new data every 60 seconds i have to exit the entire userform and reload the form. (which is no issue since that can be automated.)
But is there a way to refresh these listboxes with the the new data on the excel sheet behind without closing the entire userform and reopening it? (really just trying to make it look less tacky by not showing all of those ugly excel cells behind it every 60 seconds.)
But is there a way to refresh these listboxes with the the new data on the excel sheet behind without closing the entire userform and reopening it? (really just trying to make it look less tacky by not showing all of those ugly excel cells behind it every 60 seconds.)