I have several cells referencing a formula 'Prod7' such as cell D1
containing: Prod7(D10,D11) and E12 containing: Prod7(E10,E11), etc.

For simplicity's sake I'll say the function is:

---------------
Public Function Prod7(a, b)

If a = "" OR b = "" Then
Prod7 = ""
Elseif b < a then
RollChange.show
Else
Prod7 = "Text"
End If

End Function
---------------

RollChange is a form with 3 buttons. Let's suppose one of the button
contains the code:

---------------
Private Sub cmdRoll_Click()

<CELL = 100000 - a + b
Unload Me

End Sub
---------------

What I'm trying to figure out is what needs to replace <CELL in orde
for the value of the equation to be placed into the cell that calle
the 'Prod7' function. Thus if D10 = 1000 and D11 = 900 then D12 show
a value of 99,900 and if E10 = 50000 and E11 = 40000 then E12 shows
value of 90,000. This function is used in close to a hundred cell
across 12 worksheets.

Thanks for any help you can give on this, it's been bothering me fo
weeks now

--
Prometheu
-----------------------------------------------------------------------
Prometheus's Profile: http://www.excelforum.com/member.php...fo&userid=1569
View this thread: http://www.excelforum.com/showthread.php?threadid=27227