What's the diffrence between a 'Modal' or 'Modeless' UserForm?
How do I set it?
What the benefits/problems of one over the other?
What's typical uses for either one of them?

http://en.wikipedia.org/wiki/Modal_window

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Charlotte E." <@ wrote in message
...
What's the diffrence between a 'Modal' or 'Modeless' UserForm?
How do I set it?
What the benefits/problems of one over the other?
What's typical uses for either one of them?

But how to set it, in my UserForms?!?


Bob Phillips wrote:
http://en.wikipedia.org/wiki/Modal_window


"Charlotte E." <@ wrote in message
...
What's the diffrence between a 'Modal' or 'Modeless' UserForm?
How do I set it?
What the benefits/problems of one over the other?
What's typical uses for either one of them?

Option Explicit
Sub testme()
UserForm1.Show vbModal 'or vbModeless (vbModal is the default)
End Sub

You can look at Show in VBA's help for more info.


"Charlotte E." wrote:

What's the diffrence between a 'Modal' or 'Modeless' UserForm?
How do I set it?
What the benefits/problems of one over the other?
What's typical uses for either one of them?

--

Dave Peterson

Hi Charlotte,

With the form selected in the VBE, go to the Properties sheet and set the
ShowModal property to True or False. To see info on it select the ShowModal
line and press F1.
--
Thanks,
Shane Devenshire


"Charlotte E." wrote:

What's the diffrence between a 'Modal' or 'Modeless' UserForm?
How do I set it?
What the benefits/problems of one over the other?
What's typical uses for either one of them?