Modal or Modeless UserForm?

[Charlotte E.]

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?

 

[Bob Phillips]

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.]

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

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

 

[Dave Peterson]

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.

 

[ShaneDevenshire]

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.