Repurpose UserForm [x] Close button

[Rana Gray]

Hey everyone, hopefully a simple question -

can I code a way for the [x] button to Hide the userform instead of unload/reset my code?

 

[Herakles]

Hey everyone, hopefully a simple question -

can I code a way for the [x] button to Hide the userform instead of unload/reset my code?

Put this in the userform code module.

How are you going to make the userform visible again?

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)

    If CloseMode = vbFormControlMenu Then
    
        Me.Hide
        
        Cancel = True
    
    End If

End Sub

 

[Rana Gray]

Put this in the userform code module.

How are you going to make the userform visible again?

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)

    If CloseMode = vbFormControlMenu Then
   
        Me.Hide
       
        Cancel = True
   
    End If

End Sub

Thank you!! I have a separate ActiveX command button that's just OPEN

 

[Rana Gray]

Put this in the userform code module.

How are you going to make the userform visible again?

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)

    If CloseMode = vbFormControlMenu Then
   
        Me.Hide
       
        Cancel = True
   
    End If

End Sub

That works beautifully thank you very very much <3