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.
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.
Code:
If MsgBox("You are editing " & ("D" & ActiveCell.Row) & vbNewLine & vbNewLine & "Is this correct?", vbYesNo) = vbNo Then Exit Sub