I want to call a procedure Public Sub Test() from a userform when the user presses the OK button. The user needs to enter there postcode which is used by this procedure.
This is the code I have already in the user form:


Private Sub CommandButton1_Click()


ZipCode = lblUserForm.Text1.value
Unload lblUserForm

Exit Sub

End Sub


I have tried inserting a line ‘Call Test’ in the code shown but unfortunately this is not working. Is there any other way of calling the procedure?