Excel user form modeless

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In some of the threads there is talk about max/min and how that is useless
unless the form is loaded as a modeless form. I need to use the sheet outside
the form. Click between both. It might already have a thread on it...could
someone let me know...
thanks, you all are walking reference books, love this site.

gary
 
Hi Gary,

Try:

'=============>>
Public Sub Tester001()
Userform1.Show vbModeless
End Sub
'<<=============
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set focus on controls of modeless form 4
Modeless userform 2
Active user form 2
ZOrder of two forms 2
How to make a form modeless...??? 5
How do you resize a Multi Page User Form? 16
Referencing User Form from WorkBook 9
Wookbook Update from User Form 8

Back
Top