Sending a variable from VB to Excell

[Beavoid]

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:

Please Login or Register  to view this content.

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

[rylo]

Hi

assuming that Theta is a named cell in excel then

Please Login or Register  to view this content.

rylo

[Leith Ross]

This same question was posted at The Code Cage here

[Beavoid]

I believe that is actually my question posted again there from the other day.

I can't get any of this to work. Am I not able to put this code into a function? Does it have to go into some kind of subroutine? If so, how would a simple few lines of that code look?

I say this because right now the function is all written but doesn't seem to ever get used. Also, Functions in VB can only return one value, it seems, not send several variables into cells. Would it be possible to cheat and perhaps do an array for this instead with all of the cell value variables in the array?

[shg]

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.