Enter Key resumes macro after cell values are changed

[ThomasOES]

Hello,

I'm using a Select Case MsgBox. ("Change a Value?")
If No GoTo CarryOn.

So far ok.

However, if Yes is selected, I would like to enter the sheet at "D2" and then manually move around the sheet and make changes where necessary.

After changes are made, Press Enter Key and GoTo CarryOn.

Any help would be great.

Thanks

Tom

This is what I've started with

Select Case MsgBox("Change A Value?", vbYesNo Or vbQuestion Or vbDefaultButton1, "")
Case vbYes
Range("D2").Select
Case vbNo
GoTo CarryOn
End Select
CarryOn:

"Rest of macro"