Modal or Modeless UserForm?
 

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?

Modal or Modeless UserForm?
 

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?

Modal or Modeless UserForm?
 

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?

Modal or Modeless UserForm?
 

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

Modal or Modeless UserForm?
 

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?