ShowModal = False

  • Thread starter Thread starter Gordon
  • Start date Start date
G

Gordon

Can bring up UserForm(Modal), but cannot load it with message.

Program takes 45 seconds and is showing deck top. Want to show
UserForm with message "Stand-By". If not userForm what would you
suggest?

Thank you,
Gordon
 
Gordon,

Show the form modelessly.

UserForm1.Show vbModeless
UserForm1.lblMessage.Caption = "Stand By...."

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
Or

Load UserForm1
UserForm1.Label1.Caption = "Stand By...."
UserForm1.Show

===
Or maybe put the code in the userform_initialize procedure.
 
Back
Top