how do I get a message to appear on my userform...

  • Thread starter Thread starter rjudge
  • Start date Start date
R

rjudge

On my userform I have a commandbutton. When this is pressed it opens
new workbook that runs a number of macros and then returns to th
userform. I would like to have a message saying "please wait" appear o
my userform while my command button is doing its job. Any ideas.

Robbi
 
Robbie

One way

Create a Label on your form then update label caption

Me.Label1.Caption = "Please Wait While I process your Data"
Me.Repaint
'commands to run your macros hers
Me.Label1.Caption = "Selected Process Completed"
 
Back
Top