View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eng Teng Eng Teng is offline
external usenet poster
 
Posts: 6
Default Parameter Pasing ?

How do I get x value from Function Test() in CommandButton1_Click() function
?

Function Test(ByVal x As Integer)
x = 12
End Function

Private Sub CommandButton1_Click()
para_ret = Test(x)
MsgBox "x is " & para_ret
End Sub

Regards,
Tee