View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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