How to retain Userform Radio Button Memory after unload

  • Thread starter Thread starter swiftcode
  • Start date Start date
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
 
Move the variable declaration from sub click to a general module. Insert a
module and paste the below on top..

Public DateFilterSelection As String

If this post helps click Yes
 
Back
Top