TextBox (NotUserForm) is not updating automatically!

[hazy13]

Hi Guys,

I've got the text box drawn directly on my spredsheet (so not UserForm) where i want to display files created (kind of progress indicator). The problem is that the displayed message updates only at the end - when macro is not running anymore. So I can only get the message"Done..." which ist the last one of course : ).

Ive tried to use Repaint method but its not working!

Please Login or Register  to view this content.

Any suggestions?

The same issue was posted Here

[Andy Pope]

Try this

Please Login or Register  to view this content.

[hazy13]

Hallo Andy,

first of all thanks for you quick replay....

i have tried your method and if i use simple code as belowe than it is working perfectly

Please Login or Register  to view this content.

but in my macro it is not helping. My Macro is pretty "Big" takes couple of minutes to created all files we need. and i never used the DoEvents command in my macro (actually, not really understand what does it do).

Also in my Macro I'm getting the information from different location. My Macro runs trhough couple of sheets to get the current information.

Any suggestion where can i search for solution?

[Andy Pope]

From the help.

DoEvents passes control to the operating system. Control is returned after the operating system has finished processing the events in its queue and all keys in the SendKeys queue have been sent.

Without seeing your macro it's impossible to say.

[hazy13]

Hallo Andy

I have just for test remove most of the program (90%) and left only one loop to see if it will work but unfortunately it is sitll not working.

Is it possible that i mail it you and you have a brief look :/// - i guess it will be still bit too big to post it on forum

[hazy13]

Hi All,

First of all Thank you Andy for your help!

Below you will find my modified code:

Please Login or Register  to view this content.

So remmber to use DoEvents commad - if needed on more locations!
Make sure the Sheet with TextBox on it is active!
And last bad not least remmber to turn on back screen updating if it was turned off : )