Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Print a form
Hi,
How can I print a form with flexible data on a printer selected by the user? Thens |
#2
|
|||
|
|||
What does flexible data mean?
-- HTH RP (remove nothere from the email address if mailing direct) "Kris" wrote in message ... Hi, How can I print a form with flexible data on a printer selected by the user? Thens |
#3
|
|||
|
|||
Bob,
The form will be filled automatically with dropdownboxes en labels heving a different value. By changing a dropdownbox, the value of different labels will change. I want a print out of one such version. "Bob Phillips" wrote: What does flexible data mean? -- HTH RP (remove nothere from the email address if mailing direct) "Kris" wrote in message ... Hi, How can I print a form with flexible data on a printer selected by the user? Thens |
#4
|
|||
|
|||
-- HTH RP (remove nothere from the email address if mailing direct) "Christophero" wrote in message ... Bob, The form will be filled automatically with dropdownboxes en labels heving a different value. By changing a dropdownbox, the value of different labels will change. I want a print out of one such version. "Bob Phillips" wrote: What does flexible data mean? -- HTH RP (remove nothere from the email address if mailing direct) "Kris" wrote in message ... Hi, How can I print a form with flexible data on a printer selected by the user? Thens |
#5
|
|||
|
|||
You could add a Print button, and add this code
Private Sub cmdPrint_Click() Dim fOK As Boolean Dim sPrinter As String With Application sPrinter = .ActivePrinter fOK = .Dialogs(xlDialogPrint).Show End With If fOK Then Me.PrintForm Application.ActivePrinter = sPrinter End If End Sub -- HTH RP (remove nothere from the email address if mailing direct) "Christophero" wrote in message ... Bob, The form will be filled automatically with dropdownboxes en labels heving a different value. By changing a dropdownbox, the value of different labels will change. I want a print out of one such version. "Bob Phillips" wrote: What does flexible data mean? -- HTH RP (remove nothere from the email address if mailing direct) "Kris" wrote in message ... Hi, How can I print a form with flexible data on a printer selected by the user? Thens |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print and Print Preview don't match screen | Excel Worksheet Functions | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
Trying to delete form border, and it deletes all borders | Excel Discussion (Misc queries) | |||
Non-Breaking Space + Print Issue | Charts and Charting in Excel |