How to send a variable from a VB Module to an excel spreadshee
If this is a function called from a cell on a worksheet, then this won't work.
UDFs called from a cell in a worksheet can only return a value to the cell that
contains that function (with minor exceptions).
If this is called by a subroutine, then maybe the variables don't have anything
in them (yet). I don't see how they were declared and how they were populated.
Beavoid wrote:
Here is a snippet of what I am trying, with no results so far (no errors
either), but that could be because I haven't yet translated all of the rest
of the code:
Function BearingOutputs() As Double
Worksheets("Outputs").Range("Theta").Value = theta_eff
Worksheets("Outputs").Range("EccentricityRatio").V alue = ecc
Worksheets("Outputs").Range("AttitudeAngle").Value = att
Where Outputs is the name of the Excel worksheet tab within the file (should
it be the filename, instead?). Do I have to place anything else in the
function call?
Also, do I have to do anything to the Theta Excel cell in order to make it
take the sent variable value?
Thanks for the help!
B
"Dave Peterson" wrote:
worksheets("somesheetnamehere").range("theta").val ue = theta_eff
is one way.
Beavoid wrote:
Could someone post the solution of how to send a variable, theta_eff, to an
Excel cell named Theta?
Thanks!
B
--
Dave Peterson
--
Dave Peterson
|