Control don't refresh

C

Charlie

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top