Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'll try this again.
From Userform1, the user enters info in textboxes 1, textbox2 and textbox3, then he enters a number in textbox4. The user will then click the PRINT button on the userform. the info from textboxes 1-3 are entered on Sheet1. Here's the code to print this info onto a label, using the recorder. Application.ActivePrinter = "\\ABTAPA1491\P01VAL149107 on Ne06:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "\\ABTAPA1491\P01VAL149107 on Ne06:", Collate:=True The only thing I need is to know is how to apply the value from textbox4 to the middle line above where it says PrintOut Copies:=1 I want the value of textbox4 to replace the value of 1. This value will change each time a user runs this. I know this will probably involve putting the value of textbox4 into memory, but I don't know the proper syntax for this. If you know VBA, and understand what I'm asking for, please respond. I would appreciate it. Thanks j.o. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Axis labels wrap until print/print preview | Charts and Charting in Excel | |||
Text labels on a Userform | Excel Programming | |||
can't print data labels - on screen but don't print out | Charts and Charting in Excel | |||
Help with userform labels | Excel Programming | |||
userform labels | Excel Programming |