I am trying to call up or initialize a user form from a worksheet that has a Yes, No drop down list in cell B7. If the user selects yes in B7, I want it to pull up this user form Wall_Collar_Location. I copied the code from somewhere and it seemingly works the way I want it, but, I can not figure out the unload part. The user form has 2 option buttons and one text box. I have tried using "Unload Me" in both the command button click code and just in the sheet code "Sheet 2" as well but the user form stays open unless you hard close it with the x button. I currently use this code in my worksheet to pull up the form but what do I need to change to unload it after I click the command button?

Dim ltr As String
Dim UForm As Object
Dim i As Integer
i = 0


ltr = Sheet2.Range("B7").Value


For Each UForm In VBA.UserForms
UForm.Hide
Unload VBA.UserForms(i)
i = i + 1
Next


Select Case ltr
Case "Yes"
Wall_Collar_Location.Show

End Select



End Sub