Excel Active instead of a Userform

[Guest_imported]

Hello,

I have a userform with various command buttons on it.

Can i add a line to these commands that leave excel active and not the userform once a command as run?

 

[dsi]

If you want to close the form (i.e. unload it):

Sub cmdButton1_Click()
    'Start Excel
    Unload Me
End Sub

If you still want the form loaded, you can hide it:

Sub cmdButton1_Click()
    'Start Excel
    Me.Hide
End Sub

If you want to leave the form and just move Excel to the Top

Sub cmdButton1_Click()
    'Start Excel
    xlApp.Visible = True    
End Sub

 

[Guest_imported]

Thanks dsi

But could you tell me how to put it into this command:

Private Sub PlugRateP1_Click()
ActiveCell.FormulaR1C1 = "P1"
With Selection.Interior
.ColorIndex = 36
.Pattern = xlSolid
End With
ActiveCell.Offset(1, 0).Select
End Sub

Cheers

Andrew

 

[dsi]

If you want to unload the form (i.e. you're done with it):

Private Sub PlugRateP1_Click()
    ActiveCell.FormulaR1C1 = "P1"
    With Selection.Interior
        .ColorIndex = 36
        .Pattern = xlSolid
    End With
    ActiveCell.Offset(1, 0).Select
    [COLOR=#ff0000]Unload Me[/color]
End Sub

 

[Guest_imported]

Thanks dsi

But i still want the userform visible, but i want to be able to move around excel again without have to click back on the workbook.

Cheers

Andrew