How to retain Userform Radio Button Memory after unload

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top