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

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
 
M

mudraker

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top