ShowModal = False

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gordon - 14 Jul 2007 23:28 GMT

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

Reply to this Message

Chip Pearson - 15 Jul 2007 00:04 GMT

Gordon,

Show the form modelessly.

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

Signature

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

> Can bring up UserForm(Modal), but cannot load it with message.
>
[quoted text clipped - 4 lines]
> Thank you,
> Gordon

Reply to this Message

Dave Peterson - 15 Jul 2007 01:50 GMT

Or

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

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

> Can bring up UserForm(Modal), but cannot load it with message.
>
[quoted text clipped - 4 lines]
> Thank you,
> Gordon

Signature

Dave Peterson

Reply to this Message