Comments by Member 11386527 (Top 2 by date)

Thanks for your response. Yes, Excel VBA. (Showing my inexperience) I tried the following code but since my form pops up when clicking a button on the sheet, theis code prints the sheet rather than my form.

Private Sub CommandPrint_Click()
ActiveSheet.PrintOut
End Sub

Here is other code I found someone used but didn't know how to designate my printer. I tried changing the word printer to an IP address or LPT1 but it wouldn't complie.

Private Sub CommandPrint_Click()
' Capture the entire form including title and border.
Set Picture1.Picture = CheckRequestForm(Me)

' Print the current contents of the picture box.
PrintPictureToFitPage Printer, Picture1.Picture
Printer.EndDoc

' Clear out the picture box.
Set Picture1.Picture = Nothing
End Sub