User Defined Caption On Dialogue Box

[kelly mort]

Hello All,
I wanna know if it's possible to asign a caption to my message box other than the yes and no or the ok and cancel stuffs. If this is possible then somebody show me how to do it.

Thanks
Kelly

Sub PrintMaster()
    Dim answer As Long
            answer = MsgBox("Are you sure about this?", _
                    vbYesNo + vbDefaultButton2 + vbQuestion, _
                        "Print MasterSheet?")
                            If answer = vbYes Then
                                With Sheet1
                        .PrintOut
                    End With
                Else
            Exit Sub
        End If
End Sub

 

[Norie]

Kelly

Doesn't your message box already have a caption - 'Print MasterSheet?'?

 

[kelly mort]

@Norie, I am referring to the buttons. Sorry for not making it clear before.

Can I change the captions on the Yes button to something else?

Thanks

 

[Norie]

Kelly

Sorry but that's not possible with a standard message box.

 

[kelly mort]

Okay thanks. But can there be anything else apart from the standard?

 

[Kyle123]

You'd normally use a userform.

 

[kelly mort]

@Kyle123,
Can you show me how it's done ?

Thanks
Kelly