Passing Variables from UserForm Code to Module

[JeffGrant]

Hi All,

I know I am doing something exceptionally simple and maybe I am being silly but when I collect variables from the UserForm Code and pass it to a module, the variables loose their value.

This is the code from the OptionButton1_Click

Option Explicit
Public Horse As String, Ret As Double

Private Sub OptionButton1_Click()
Sheet1.Activate
' Read Variables for when more than one horse is selected
        Horse = Range("T3").Value
        Ret = Range("T2").Value
        Call CopyResults
End Sub

In the VBA Module itself, I also have

Option Explicit
Public Horse As String, Ret As Double

In the OptionButton1_Click Code, the variable gets assigned properly, because I have checked that with a msgbox, but when I call the CopyResults Routine to wrtite the variables out to another sheet all I get is a blank for the horse name and 0 for the returned value.

What am I missing ?

Cheers

 

[mohadin]

Hi

Public Horse As String, Ret As Double

Delete this one of them

 

[JeffGrant]

Hi Mohadin...

Remarkable when I am so close to the trees that i cant see the forest. Thanks

 

[mohadin]

Things happens
Thank you for the feedback
Be happy and safe