Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting data from a sku for shipping | Excel Worksheet Functions | |||
EXCEL WITH BARTENDER LABEL PROGRAM | Excel Discussion (Misc queries) | |||
shipping / receiving log template | Excel Discussion (Misc queries) | |||
Calculating shipping costs | New Users to Excel | |||
shipping costs using if then | Excel Worksheet Functions |