Hi,

I have a very basic question concerning the VBA code in excel. I would like
to know how can I decide into which cell does the excel enter the answer of
my function?

For example, if my function goes as follows,
function test(s+b)
test=s+b
end function

so how can i tell the program that the result of the function should be
shown automatically in cell e.g "C2"?

Regards,
Vepa

Vepa,
First, to write your function, you need to separate the arguments:
Public function test (arg1 as range, arg2 as range)
....etc

Then you have to enter the function and arguments in cell C2.
=test(A1,C14)

same as you do for any other Excel WS formula.

NickHK

"Vepa" wrote in message
...
Hi,

I have a very basic question concerning the VBA code in excel. I would
like
to know how can I decide into which cell does the excel enter the answer
of
my function?

For example, if my function goes as follows,
function test(s+b)
test=s+b
end function

so how can i tell the program that the result of the function should be
shown automatically in cell e.g "C2"?

Regards,
Vepa

So is it impossible for me to do, for example, a result table where all the
results of calculations involved in the function could be shown
automatically? With this I mean that I don´t have to do everything manually
by using normal excel functions.

"NickHK" kirjoitti:

Vepa,
First, to write your function, you need to separate the arguments:
Public function test (arg1 as range, arg2 as range)
....etc

Then you have to enter the function and arguments in cell C2.
=test(A1,C14)

same as you do for any other Excel WS formula.

NickHK

"Vepa" wrote in message
...
Hi,

I have a very basic question concerning the VBA code in excel. I would
like
to know how can I decide into which cell does the excel enter the answer
of
my function?

For example, if my function goes as follows,
function test(s+b)
test=s+b
end function

so how can i tell the program that the result of the function should be
shown automatically in cell e.g "C2"?

Regards,
Vepa

<to do, for example, a result table

Look at the DataTable command

Or try to explain a bit more clearly what you are trying to achieve, so we
can suggest alternative ways to do that.

--
Kind regards,

Niek Otten

"Vepa" wrote in message
...
So is it impossible for me to do, for example, a result table where all
the
results of calculations involved in the function could be shown
automatically? With this I mean that I don´t have to do everything
manually
by using normal excel functions.

"NickHK" kirjoitti:

Vepa,
First, to write your function, you need to separate the arguments:
Public function test (arg1 as range, arg2 as range)
....etc

Then you have to enter the function and arguments in cell C2.
=test(A1,C14)

same as you do for any other Excel WS formula.

NickHK

"Vepa" wrote in message
...
Hi,

I have a very basic question concerning the VBA code in excel. I would
like
to know how can I decide into which cell does the excel enter the
answer
of
my function?

For example, if my function goes as follows,
function test(s+b)
test=s+b
end function

so how can i tell the program that the result of the function should be
shown automatically in cell e.g "C2"?

Regards,
Vepa