Thread
:
UDF: how to get value of the argument's adjacent cell?
View Single Post
#
6
Posted to microsoft.public.excel.programming
David Prout
external usenet poster
Posts: 4
UDF: how to get value of the argument's adjacent cell?
Add the function below into a module
Function Res(ValA, ValB)
Res = ValA * ValB
End Function
in cell B4 (or anywhere) type
=res(A1,A3)
DavidP
On 12 Apr 2004 21:42:12 -0700,
(Andrew) wrote:
Hi
I need to write a function which will use two arguments, e.g. vala and
valb (not adjacent) as input values. This function should refer
adjacent cells of vala and valb to calculate result for example:
A B
1 adj_vala vala
2
3 adj_valb valb
4 adj_vala + adj_valb
So UDF to calculate B4, as I see it, will lool like (I don't know how
to get adj_vala and adj_valb in the UDF below):
Function Result(vala As Long, valb As Long) As Long
Dim adj_vala As Long
Dim adj_valb As Long
' get value of the left adjacent cell of vala
adj_vala = ???
' get value of the left adjacent cell of valb
adj_valb = ???
Result = adj_vala + adj_valb
End Function
The example above describes simplifed version of more complex logic I
have to implement, but idea will be the same...
Thanks a lot,
Andrew
Reply With Quote
David Prout
View Public Profile
Find all posts by David Prout