View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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