MsgBox show cell value

[sramsay]

Major mind block this morning.
I know this is simple but cannot seem to get my head around it today

The below code for a msgbox needs to show the value of the cell in Coulumn D for the active cell.
At the moment it is only showing "D10" if im in row 10 for example.

If MsgBox("You are editing " & ("D" & ActiveCell.Row) & vbNewLine & vbNewLine & "Is this correct?", vbYesNo) = vbNo Then Exit Sub

 

[FormR]

Hi try:

If MsgBox("You are editing " & Range("D" & ActiveCell.Row).Value & vbNewLine & vbNewLine & "Is this correct?", vbYesNo) = vbNo Then Exit Sub

 

[sramsay]

Hi try:

If MsgBox("You are editing " & Range("D" & ActiveCell.Row).Value & vbNewLine & vbNewLine & "Is this correct?", vbYesNo) = vbNo Then Exit Sub

Works a treat.

Thank you very much