Excel 2010 :: Msg Box With Ok And Cancel Buttons

I'm trying to make a msg box with ok and cancel buttons. The cancel button should continue the macro, the ok button ends the macro. I'm new to making message boxes.

I keep getting a compile error and it says it expects =

Here's what I have so far:

Code:
If WorksheetFunction.CountBlank(Intersect(Columns("I"), ActiveSheet.ListObjects(1).Range)) Then
MsgBox(Prompt:="Enter a status, moron. Click Ok to return and add a status, click Cancel to throw caution to the wind and continue",buttons:=vbOKCancel, title:="blank status")
End If
If Answer = vbOK Then Exit Sub
End If

I also don't know if my End Ifs are in the right places. I haven't been able to test my code because I keep getting this compile error.

Excel 2010