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