You mean something like this ?

'<Userform code
Private Sub CommandButton1_Click()
MsgBox MyFunction(20, 10)
End Sub
'</Userform code

'<Module code
Public Function MyFunction(Arg1 As Long, Arg2 As Long) As Long
MyFunction = Arg1 * Arg2
End Function

'</Module code

NickHK

"CSUS_CE_Student" wrote in message
...
I am trying to make a userform to return some data from the spreadsheet
after
the analysis is done in a public Sub. How do I call the variable from
the
public module to the userform?