Excel user form modeless
 

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

Excel user form modeless
 

Hi Gary,

Try:

'=============
Public Sub Tester001()
Userform1.Show vbModeless
End Sub
'<<=============


---
Regards,
Norman



"Hammer1947" wrote in message
...
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