Sending a variable from VB to Excell

Hello,

I currently have the task of sending variables to excel cells in a spreadsheet after they are calculated in a function. I don't know much about VB and am converting from a Java program to a Visual Basic Module

Here is an example of the original JAVA code:

peakTemp = 2 * theta_eff - tamb
    setEccentricityRatio(ecc);
    setAttitudeAngle(att);
    setSommerfeldNo(som);
    setPressureAverage(pressure_average);
    setDimensionlessOilFlow(dof);
    setDimensionlessFrictionCoef(dfc);
    setFilmThickness(clearance_eff);
    setPowerloss(loss);
    setOilFlow(flowTotal );
    setTheta(theta_eff) ;
    setPeakTemperature(peakTemp);
    setDeltaTheta(deltaTheta);

So, the VB functions don't call any variables, but need to send variables like Theta_eff to the Excel Cell Theta. Can somebody post an example of how this would be done for one of these variables?

If this is already discussed somewhere, I apologize.

Thanks!

B

This same question was posted at The Code Cage here

Functions in VB can only return one value, it seems, not send several variables into cells

A function can return one value or an array of values, but those values are returned solely to the calling cells in which the function appears.

Would it be possible to cheat ...

Maybe, if we knew what you were trying to do.