Excel: informative Form blank while processing macro

[azzi2000]

I am using a long macro to process the steps.
However I need to inform the user the steps via window that Are taken. (ie: Step 1 of 5....)
I am using a Form to show the steps while executing Macro: MyForm.show vbModeless
Myform.Caption = "Download"
MyForm.lblmessage = "Please Wait - Step 1 of 5"
...
..
MyForm.lblmessage = "Please Wait - Step 2 of 5"
...

the only thing that the form will display blank no wording... Am I missing something ?
Please advice,
Dré

 

[DPlank]

Suggest you search this forum for words like:

progress bar

Should point you in the right direction..

Cheers,
Dave

Probably the only Test Analyst on Tek-Tips...therefore whatever it was that went wrong, I'm to blame...

animadverto vos in Abyssus!

Take a look at Forum1393 & sign up if you'd like

 

[kodr]

I tend to use 'application.statusbar' when I need to inform a user of the progress of a program.

 

[TonyJollans]

I answered something very similar earlier this week. It does depend on exactly how you're coding but try making use of:
[blue][tt] YourForm.Repaint[/tt][/blue]
or possibly:
[blue][tt] DoEvents[/tt][/blue]
at appropriate points.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[azzi2000]

.repaint did it
Thank you.
Dré