Assuming your userform is named UserForm1 . . . add this macro to a standard
module to open the form:
Sub OpenForm
UserForm1.Show
End Sub
To get back to the worksheet, use this line of code to close the user form:
Unload Me
For example, if you wanted to close the form with a command button:
Private Sub CommandButton1_Click()
Unload Me
End Sub
----------------------------
Regards,
John Mansfield
http://www.pdbook.com
"maxzsim" wrote:
Hi,
I have created a user form but
1) how do i get it to run once i opened the excel file
2) the user form will populate the data into a worksheet , but how do i make
that worksheet to get the focus after the populate process
appreciate any advise
tks & rdgs