Add "Print" button to my msg box

[nirvehex]

Hi I have a code:

Sub ScopeofWorkInstructions()


Dim response As VbMsgBoxResult
Dim ws As Worksheet


response = MsgBox("                                             SCOPE OF WORK INSTRUCTIONS:" _
& vbNewLine & " " _
& vbNewLine & "1. Please fill out as much information as possible." _
& vbNewLine & " " _
& vbNewLine & "2. Use the Notes column for additional information discussed." _
& vbNewLine & " " _
& vbNewLine & "3. Download the Client's Logo and insert it as a picture sized to fit within the logo box." _
& vbNewLine & " " _
& vbNewLine & "4. Please return to the Navigation and check the completion box when finished." _
, vbOKCancel)
If response = vbCancel Then Exit Sub


Set ws = Worksheets("Scope of Work")
ws.Activate


End Sub

Can I add a print button which will print what's in the msgbox?

Thank you!

 

[JoeMo]

You can't print directly from a msgbox. You either need to write the message to somewhere on your worksheet or use a userform with a text box containing the message and print it from there.

 

[jolivanes]

I guess the OP didn't believe you Joe.
Add "Print" button to my msg box

Where of course he got the same answer.
A polite thank you would have been nice though.

 

[nirvehex]

Oh come on..haha, I can't double dip with some help from the VBA forum? I do enjoy and appreciate both forums thoroughly. Joe, thank you for the response. I kind of figured that, but wasn't sure. Also, in my defense I did post that one to VBA before I saw you're response.

 

[nirvehex]

So question for both of you. More of an opinion/design question.

Say you had a macro. Once run, it first pops up a msgbox with instructions on what the macro is going to do, and what input it needs from the user. You can press OK to proceed or Cancel to exit the msgbox. I want the user to be able to print these instructions for reference. What would be best way to go about allowing the user to print what's in the msgbox?

I was thinking, maybe have this text pre-written elsewhere and create like was said, a "Userform" instead of a msgbox so I can add a print button to the userform which opens up the same thing as Control+P would do on a windows OS.

Any other ideas? Thanks!