Custom Message Box in Macro

Closed
smuneeb
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
- Nov 28, 2015 at 05:02 AM
Hello,

I would like to ask that
how could custom message box having custom button will be created.
I have a code given below I need a changes which is marked as bold
Changes are instead of "Yes" Button it display "Awd Sheet" Button and
Instead of "No" Button it display "Ats Sheet" Button and
Instead of "Cancel" Button it display "Close" Buttone
Sub Format_Preview()
Dim Check As Integer
Check = MsgBox("Would you like to apply format to Award Sheet or Attendance Sheet?" _
& vbNewLine & "For Award Sheet click Yes OR" _
& vbNewLine & "For Attendance Sheet click No OR" _
& vbNewLine & "Click Cancel to close", vbInformation + vbYesNoCancel, "Format Preview")
If Check = vbYes Then
Call AwS_Format
ElseIf Check = vbNo Then
Call AtS_Format
ElseIf Check = vbCancel Then
UserForm1.Hide
End If
End Sub