blank userform

[Alan Yim]

Hi folks,

I have a spreadsheet that connects to the AS400 for
updating prices. I have a macro that does all of this as
well as formats all the data but it does take a while for
it to run through all the data so I've created a userform
with a simple message that says to "Updating. Please
wait..." The userform comes up when the user runs the
macro (button activated) and the macro runs in the
background until finished, then the userform disappears
and the user can continue on.

My problem is that for some reason the userform appears
but the form is blank. The label with the "wait" message
and the form itself is blank/white. It appears to be
working as the macro is running and disappears when it's
finished.

Is there a setting I'm missing?

Thanks,

Alan

 

[Patrick Molloy]

add a

DoEvents

line to release the thread and allow the OS to referesh the screen

 

[Alan Yim]

Thanks, I'll give that a try.

Alan

-----Original Message-----
add a

DoEvents

line to release the thread and allow the OS to referesh the screen

--
Patrick Molloy
Microsoft Excel MVP
----------------------------------



.

 

[Guest]

Perfect! That was it!

Thanks again!

Alan

-----Original Message-----
add a

DoEvents

line to release the thread and allow the OS to referesh the screen

--
Patrick Molloy
Microsoft Excel MVP
----------------------------------



.