Using button in a userform

[deanl33069]

HI All
I created a userform and added buttons to open different sheets. they seem to work OK ,but the form is ALWAYS on top .'
How do I get the form to the back and the selected sheet to be active?

TYVM

 

[Fluff]

You could hide the userform.

Private Sub CommandButton2_Click()
'dosomething
Me.Hide
End Sub

 

[deanl33069]

thankyou
works well,
how do i reopen the form from the worksheet?
I created a button and tried, "open " Forms("JFSmainsheet").open
but i must be doing something wrong

 

[Fluff]

Use

Userform1.Show

Change Userform1 to the name of your form.

 

[elynoy]

you can set it to userform1.show False so you can keep clicking and using the form too.

eLy