How do I change a userform while calculations are ongoing.

[joebbb]

I have written a form based application which interactively allows a user to set up a model puzzle. The structure is entirely form based. After all the setup is done the user may activate an algorithm to solve the puzzle. This algorithm may take many minutes to run. I would like to be able to update the user, as to what is happening, while the processing is going on. Thank you very much for any suggestions or help you can provide.

Joe

[kev_]

How about using the Status Bar

Please Login or Register  to view this content.

[joebbb]

I am sure that will work - Thank you very much.
I was hoping there would be a way to either initiate a new form or using the current form change it as the algorithm is processing.
Do some processing update "label" in current form.
Again Thank you very much.

[kev_]

Try this and see if you prefer it

Open the file, enable macros and click on Run

(The VBA contains a loop to simulate your code running)
At various stages in the code (here at the end of each loop)
- the code writes a status update to cell A1
- the UserForm is refreshed by being re-initialized
- TextBox1 takes the latest value from cell A1

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.