| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
blank userform
|
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
| Excel 2002: Return blank when VLOOKUP on blank cells | Excel Discussion (Misc queries) | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions | |||
| Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
Linear Mode
