How to make Form Modeless

  • Thread starter Thread starter Jim May
  • Start date Start date
J

Jim May

With:

Private Sub UserForm_Initialize()
UserForm1.TextBox1.Text = Sheets("Sheet2").Range("A1").Value
End Sub

How do I make Userform1 Modeless?
 
Hi Jim,

Try:

'=============>>
Public Sub Tester()
UserForm1.Show vbModeless
End Sub
'<<=============
 
Thanks Norman,

I guess it can be done this way,

Private Sub Workbook_Open()
UserForm1.Show vbModeless
End Sub

as well... (seems to work OK, without a problem..)

Jim
 
Back
Top