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? :)
