ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   VBA function (https://www.excelbanter.com/excel-discussion-misc-queries/43642-vba-function.html)

Jeff

VBA function
 
I have a function in VBA, and it depends on two variables. It is called in
another function.

Blend_Qx(A,B)

The function Blend_Qx(A,B) takes A and B, then gives a new value C in the
function. Is there anyway to pass the variable C to the main program.

like

C = Blend_Qx(A,B) ?

KL

Hi Jeff,

That's exactly the way to do it :-)

Regards,
KL


"Jeff" wrote in message
...
I have a function in VBA, and it depends on two variables. It is called in
another function.

Blend_Qx(A,B)

The function Blend_Qx(A,B) takes A and B, then gives a new value C in the
function. Is there anyway to pass the variable C to the main program.

like

C = Blend_Qx(A,B) ?





All times are GMT +1. The time now is 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com