Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Screen Updating | Excel Worksheet Functions | |||
Screen updating | Charts and Charting in Excel | |||
Screen updating | Excel Programming | |||
Screen updating | Excel Programming | |||
Screen Updating | Excel Programming |