Rename Buttons For YesNoCancel VBA

[clark544]

Here is my code:

Private Sub Workbook_Open()
    Select Case MsgBox("my question?", vbYesNoCancel)
    Case Is = vbYes
       'Yes Code will sort Moistures and Owners
    Case Is = vbNo
        'NO code will sort Moistures and Fields
    Case Is = vbCancel
        ' Will Sort neither and allow for data entry
    Case Else
        Debug.Print "Whoops"
    End Select
End Sub

I want to rename the Yes, no, and cancel buttons to Pay Owner, Field Close Out, and Data entry. How can I go about doing that? Is there a simple way to to rename them ?

 

[clark544]

Do you mean this bit which was included earlier

Private Sub Workbook_Open()
UserFormName.Show
End Sub

Yeah, sorry, I must have missed it in my excitement to get this thing working.

Thanks again!

 

[clark544]

I went with the userform, but what does the .me on the end mean? I think that's giving me an argument not optional error.

Fixed! You need to remove the . (dot) from .me