Help with VBA Goal Seek Minimum or IF Statement

[rwilliams09]

I have the following code, but I would like to have the Goal Seek stop once P22 reaches a minimum of 0. Is this possible? Basically I have a model with two drivers of revenue. And the Goal Seek (aka breakeven) on one of them is 0.00 if the other revenue driver is sufficient. Thus, I do not need to see that P22 can be -1,000,000,000 or something like that. Not sure if that is possible within VBA...

Private Sub CommandButton2_Click()If Range("Q9").Value = 2 Then
        Application.ScreenUpdating = False
        With Range("Q11")
            .GoalSeek Goal:=0, ChangingCell:=Range("P22")
        End With
        Application.ScreenUpdating = True
    End If
End Sub

 

[rwilliams09]

Anyone have any idea with this? Thanks!