Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Creating a Form to print after adding data from UserForm

0

Trying my best to keep this as simple as possible and make it easier for future searchs.

I've got a 4 part UserForm that I add data to which compiles onto the spreadsheet.

Its already set to just print the userform but I would like it to print just the account number and account name on a 3x2 label.

Can this be done and how?

Thanks

excelmacros-vbaprinting
MS Office Version: 2016
posted by: JamesTurnham on Wed Sep 11, 2019 at 2:42 pm
Answer
Discuss

Discussion

Your question lacks information about the workflow. Most probably you will either need to change the printer between printing the form and printing the label, or you will want to change the paper supply. Since the information required for printing the label has already been entered your problem would be one of sequencing. But by the way you ask the question you make it into a problem of printing a label. This will lead to duplication in the workflow.
Variatus (rep: 4889) Sep 14, '19 at 3:51 am
Add to Discussion

Answers

0

try the attached. Needed to creat a second userform.

Pass the values

print

then close form 2

You will need to set up the size of the form to fit your label

posted by: k1w1sm (rep: 197) on Thu Sep 12, 2019 at 5:43 pm
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login