S
swiftcode
Hi all,
I have created a Userform with 3 radio options, this is called as a
subroutine within another macro, and i cannot seem to keep the memory of the
selection choice "DateFilterSelection" after it unloads.
Can anyone help me. Thank you in advance.
The code is as follows:
Private Sub OK_Click()
Dim DateFilterSelection As String
If StandardDate = True Then
DateFilterSelection = "Standard"
ElseIf BritishDate = True Then
DateFilterSelection = "British"
ElseIf AmericanDate = True Then
DateFilterSelection = "American"
End If
Unload Me
End Sub
I have created a Userform with 3 radio options, this is called as a
subroutine within another macro, and i cannot seem to keep the memory of the
selection choice "DateFilterSelection" after it unloads.
Can anyone help me. Thank you in advance.
The code is as follows:
Private Sub OK_Click()
Dim DateFilterSelection As String
If StandardDate = True Then
DateFilterSelection = "Standard"
ElseIf BritishDate = True Then
DateFilterSelection = "British"
ElseIf AmericanDate = True Then
DateFilterSelection = "American"
End If
Unload Me
End Sub