How to make Form Modeless

[Jim May]

With:

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

How do I make Userform1 Modeless?

 

[Norman Jones]

Hi Jim,

Try:

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

 

[Jim May]

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