Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have some 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 active 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 nd. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Screen updating | Charts and Charting in Excel | |||
Screen updating | Excel Programming | |||
Screen updating | Excel Programming | |||
Screen Updating | Excel Programming | |||
Screen Updating | Excel Programming |