User Defined Message box

[pedro915]

I need help with with creating 2 message boxs to show only when the results entered by the user in cell B2 is higher or lower then number in cells D8 and D9.

the scenario is as follows:

if the user enters for example 8 in cell B2 and Cell D8 contains 6 then the message box should appear and show the message "ur result is 2" and the same if the number entered in cell B2 is lower then the number in cell D9 then a message box should appear sayin (your result is XX).

I don't know whats the best practice to do it and how to achieve it, I would appreciate your help. im using excel 2007 btw

 

[JamesW]

Hi,

Welcome to the board.

Try this:

Alt + F11 -> Double click on your sheet in the project window on the left -> Paste the below into the code window:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("B2")) Is Nothing Then
        If Target.Value > Target.Offset(6, 2).Value Then
            MsgBox "Your value is: " & Target.Value - Target.Offset(6, 2).Value
        ElseIf Target.Value < Target.Offset(7, 2).Value Then
            MsgBox "Your value is: " & Target.Value - Target.Offset(7, 2).Value
        End If
    End If
End Sub

Nothing happens if they are equal using the above, is this correct?

 

[pedro915]

Thank you James
It is correct however I entered the code and nothing happened.

I just wanna add that Cells D8 and D9 also changes by the user input it shows the maximum and minimum of user input range after a calculation.
so if the user enters 8 and the maximum for his score is calculated 6 in cell d8 then a massage box should appear saying your score is higher it should be 2 scored lower and so on if his score is below the calculated minnimum.
I also wanna add that all cells are numeric

 

[pedro915]

and can I put msg box 1 in cell E8 and msg box 2 in cell E9