I have a sub that asks a question in a msgbox, but I would prefer to use different labels on the buttons than the default options.

I would like a VIEW button and an IGNORE button. Is that possible?

Here is my code:

Sub question1()

answer = MsgBox("Some data is missing from the Product Listings sheet. Do you want to View the missing data?", vbYesNo + vbExclamation)
If answer = vbYes Then Sheets("MISSING DATA").Activate

End Sub