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
|