blank userform
 

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

blank userform
 

add a

DoEvents

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

--
Patrick Molloy
Microsoft Excel MVP
----------------------------------
"Alan Yim" wrote in message
...
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

blank userform
 

Insufficient system memory perhaps?

D.S.
"Alan Yim" wrote in message ...
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

blank userform
 

Lack of system memory perhaps?

D.S.

"Alan Yim" wrote in message ...
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

blank userform
 

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
----------------------------------
"Alan Yim" wrote in message
...
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


.

blank userform
 

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
----------------------------------
"Alan Yim" wrote in message
...
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


.