Screen Updating
I have a part of code that runs having ScreenUpdating set to False,
then activates a sheet, and sets ScreenUpdating to True: Application.ScreenUpdating = False .... .... Sheets(1).Activate Application.ScreenUpdating = True The Sheet(1) contains a ListBox (ActiveX Control), and although the sheet is activated before ScreenUpdating is set to True, the part of the screen that contains the ListBox is not updated, and shows the corresponding part of the screen of the previous sheet (the one that was activated before Sheets(1).Activate). Is there a method to specifically update the screen or the ListBox? The only way I have found to have the listbox updated, is to turn on ScreenUpdating before the sheet activation: Application.ScreenUpdating = False .... .... Application.ScreenUpdating = True Sheets(1).Activate Is there another way? thanks in advance KG. |
All times are GMT +1. The time now is 04:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com