Hi,
I'm using some combobox amd listbox controls on one sheet of my workbook.
These controls are refreshed from several sources (other sheets, other
workbooks.) They work fine. The problem is when I refresh them I can't use
Application.ScreenUpdating = No
(macro tasks to update controls)
Application.ScreenUpdating = Yes
as I do when I'm performing other tasks on sheets. If I turn off screen
updating the controls won't refresh. They remain empty, or in some cases
they become "transparent" and I can see sheet gridlines through them when I
turn screen updating on.
For now I'm not using Application.ScreenUpdating and everything works fine
(other than the screen flashing.) Is there a workaround for this problem?
Regards,
Charlie
P.S.
Global Const Yes As Boolean = True
Global Const No As Boolean = False
|