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

Similar Threads

Userform problem 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Must something be done to a userform? 2
problems adding botton to a menu bar 3
Userform from a Userform Problem 1
Userform to ignore current calculation 1
How to evoke a hidden userform? 1
Userform Save data To Worksheet & File 1

Top