UserForm Suggestions

[bmkelly]

Hello,

I have a few Modules that my UserForm calls in the ComboBox, however I am wondering if there's a way I can have the UserForm to close when the code is completed. I have tried inserting

UserForm.Hide

at the end of each of my Modules that the ComboBox calls and it did in fact hide the the UserForm but when I would open the UserForm back up it would keep my previous selection already there and therefor would require me to have to close out and open again to have the selections blank.
If you have any suggestions/updates or even a different route than what I am currently attempting, I am open ears!

Here is my current code for my UserForm:

Private Sub UserForm_Initialize()

    ComboBox.AddItem "Insert Rows"
    ComboBox.AddItem "Priors Prep"
    ComboBox.AddItem "Submit Priors"
    ComboBox.AddItem "Pricing"
    ComboBox.AddItem "Regular CS"
    
End Sub
Private Sub ComboBox_Change()

    If ComboBox.Value = "Priors Prep" Then
        Call PriorsPrep
        
    ElseIf ComboBox.Value = "Submit Priors" Then
        Call SubmitPriors
        
    ElseIf ComboBox.Value = "Pricing" Then
        Call Pricing
            
    ElseIf ComboBox.Value = "Insert Rows" Then
        Call InsertRows
            
    ElseIf ComboBox.Value = "Regular CS" Then
        Call RegularCS
       
    End If

End Sub

 

[My Aswer Is This]

Instead of Hide Me use:
Unload Me

 

[My Aswer Is This]

And you could write your script like this using Case instead of If:

Private Sub ComboBox1_Change()
'Modified  3/8/2022  12:12:22 AM  EDT

    Select Case ComboBox1.Value

        Case "Priors Prep": Call PriorsPrep
        Case "Submit Priors": Call SubmitPriors
        Case "Pricing": Call Pricing
        Case "Insert Rows": Call InsertRows
        Case "Regular CS": Call RegularCS
    End Select
End Sub

 

[bmkelly]

Instead of Hide Me use:
Unload Me

As in I would just put

Unload Me

before End Sub on each of my modules? I originally had

UserForm.Hide

 

[bmkelly]

Disregard! I apparently need to drink more coffee this morning. Thank you, it successfully worked!