Here's what I'm looking to do in Excel:

User inputs data in cell C7

A function in cell C11 calculates

A function in cell C12 calculates

I want to ensure that both C11 and C12 are positive based on C7 input

If they are not, I want a msgbox to appear saying, "Enter a Larger Value."

I used the Change event over the Calculate event because it's my understanding that the Calculate event will not work with functions.

Here's what I've got so far:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

If Range("C11:C12") < 0 then

MsgBox "Enter Larger Value."

End If

End Sub

Can anyone help