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