How would I go about creating this button?

[jackjack583]

Hi there,

Just wondering how I would go about creating this button? The button has two options, 1 to either Print or 2 Print to PDF. I would need this to be recorded as a macro and then assign the button. So create a button and give it 2 options but how do I do this?

Any help is appreciated.

Thank you,

Jack

 

[Logit]

.
To accomplish what you are seeking, by way of a MsgBox only, will require a substantial amount of coding.

A simpler approach would be to create a UserForm that looks like a MsgBox, insert three buttons on the UserForm "Print Doc" / "Print to PDF" / "Cancel".

Then for each form button, assign a macro to accomplish the action stated on the button.

Are you ok accomplishing that or will you require assistance ?

 

[Fazza]

maybe something like this?

Sub test()

    Dim vbAns As Variant


    vbAns = MsgBox(Prompt:="Yes to print, No for pdf", Buttons:=vbYesNoCancel + vbDefaultButton2, Title:="Print to paper?")


    Select Case vbAns
        
        Case vbyes
            Debug.Print "print to printer"
        
        Case vbNo
            Debug.Print "print to pdf"
            
        Case Else
    End Select


End Sub

 

[daverunt]

Two buttons right next to each other can look like a split button?