I don't want to control PlanMaker from BasicMaker, just put the result of a BasicMaker function into a cell.
I have a file Jim.bas with the following:
Code: Select all
function JimJam as integer
JimJam = 1000
end function
Jim
Code: Select all
function JimJam as integer
JimJam = 1000
end function
Now it’s time to call this VBA Function procedure from a worksheet formula. Activate a worksheet in the same workbook that holds the CubeRoot function definition. Then enter the following formula in any cell:
=CubeRoot(1728)
The cell displays 12, which is indeed the cube root of 1,728.