Progress notification with screen updating set to FALSE

[mark hansen]

I have search this and other forums to see if I could find a way to notify a user of the progress of an update with screen updating set to false. Although I found other interesting ways to use screen updating, I haven't found any answers the questions I have.

I have an update process that pulls in the contents of 4 files so we can use current data. This process runs in about 24 seconds with screening updating set to TRUE or FALSE.... But of course with Screen updating turned off, the user won't see the screen flashing as it copies in the contents of each file - a more polished look for the product.

As the process takes 24 seconds, I'd like to keep them apprised of the progress. I tried turning screen updating to TRUE, make a cell say something regarding the progress, then set Screen updating back to FALSE. Next time for an progress update, perform the same tasks, Screen updating = TRUE, change the contents of the cell, and set updating to FALSE.

That's not work so I was wondering if there are any other ideas. Perhaps a user form, or a text box. Will those update even though screen updating is set to FALSE?

Any other way to "crack this nut"

Thanks for any ideas,
Mark

 

[VBE313]

maybe

application.cursor = xlwait

so you can have the mouse with the loading circle.

 

[mark hansen]

I do get the dreaded hour glass because of my settings. So that's something.

After it's all done I have a message box pop up telling them it's done... But I was hope to get something to show between after file 1 and before file 2 --- then after file 2 and before file 3 and then the final message. (which I have done the final message.

Well, it's not a show stopper. I wanted to add something for them to watch while it's updating.

Thanks for your ideas.

 

[dispelthemyth]

Just create a simple userform and put a progress message in it, updating the test as you go. You might have to use the Repaint command to update the text.

 

[mark hansen]

Thanks for the idea [U]dispelthemyth,[/U] that seems to be working nicely. I have four boxes that change color as each file is brought in and a label box explaining what file is being brought in now.