Popup Message with data from another cell

[sd7000]

Hi all,
I have created a popup message when a cell falls below a value. What I would like to do, is if that value is below 0, then I would like the text from another cell be put into my popup message at the beginning of the message. Example, if the cell value in P5 <0, then my popup message would be "(text from cell B5), you have exceeded your hours"
Thanks in advance, Steve

 

[jim may]

Post your code (that is working) BEFORE the improvemnet you now wish to make.

 

[sd7000]

Sorry about that, here is the code.

Private Sub Worksheet_Calculate()
    If [P5] < 0 Then MsgBox "You have exceeded your allotted Hours, please correct.", vbOKOnly + vbCritical, "Holiday Hours"
End Sub

 

[sd7000]

I got it, thanks for the help. Here is what I used. Range("B5").Value &