Building a shipping label program
I want to build a template that when the user keys in a customer number, it
fills in the template with the shipping address and allows them to ask how many labels and have them print on our label printer. I would love the general outline on how to do this. Thanks much Greg |
Building a shipping label program
Data ValidationList dropdown menu for the entry of the number.
VLOOKUP tables formula(s) for the filling-in of addresses. You would need VBA to use an InputBox to collect the number of labels then print that many. example code. Sub print_labels() Dim numlabs As Integer numlabs = InputBox("Enter number of labels to print") ActiveSheet.Range("C4:F7").PrintOut Copies:=numlabs End Sub Gord Dibben MS Excel MVP On Wed, 10 Dec 2008 14:08:03 -0800, Lost in excel wrote: I want to build a template that when the user keys in a customer number, it fills in the template with the shipping address and allows them to ask how many labels and have them print on our label printer. I would love the general outline on how to do this. Thanks much Greg |
All times are GMT +1. The time now is 05:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com