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