Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA - get result from
Hi,
I am trying to use a function (maybe it is technically a macro - I dont know)- here is my problem. The function has 3 "input" variables declared as doubles, and based on these values the function assigns values to 3 output "variables". The output variables are declared inside the function - so I just want to get them - without declaring global variables. So in the code below I want to get variables "get1 - get3" Sub MainTest() Dim get1 As Double Dim get2 As Double Dim get3 As Double Call TestFunct1(1, 2, 3) End Sub Sub TestFunct1(X, Y, Z) Dim var1 As Double Dim var2 As Double Dim var3 As Double var1 = 1 * X var2 = 2 * Y var3 = 3 * Z End Sub Thanks for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA - get result from
like ...?
Dim get1 As Double Dim get2 As Double Dim get3 As Double Sub MainTest() Call TestFunct1(1, 2, 3) Debug.Print get1 Debug.Print get2 Debug.Print get3 End Sub Sub TestFunct1(X, Y, Z) get1 = 1 * X get2 = 2 * Y get3 = 3 * Z End Sub "Jeff" wrote: Hi, I am trying to use a function (maybe it is technically a macro - I dont know)- here is my problem. The function has 3 "input" variables declared as doubles, and based on these values the function assigns values to 3 output "variables". The output variables are declared inside the function - so I just want to get them - without declaring global variables. So in the code below I want to get variables "get1 - get3" Sub MainTest() Dim get1 As Double Dim get2 As Double Dim get3 As Double Call TestFunct1(1, 2, 3) End Sub Sub TestFunct1(X, Y, Z) Dim var1 As Double Dim var2 As Double Dim var3 As Double var1 = 1 * X var2 = 2 * Y var3 = 3 * Z End Sub Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel result return wrong calcuation result | Excel Worksheet Functions | |||
excel result return wrong calcuation result | Excel Worksheet Functions | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
Importing result from Access query to Excel but the result only c. | Excel Discussion (Misc queries) | |||
vlookup based on random result returns incorrect result | Excel Worksheet Functions |