eitan cohen
05-23-2013, 08:30 AM
hello
i'm using excel 2010
i have a simple userform with 3 textboxes, to enter data to table.
textbox1=part number
textbox2=qty
textbox3=amount of labels
in the third box i want the user to specify how many rows he wants to copy the data in textbox1 & textbox2. All the 3 textboxes accept only numbers.
basically i'm looking for somthing like the code in KB called "Copying & Inserting Rows" by dazwm.
My target in the end is to create table of labels and to use mail merge in Word Application.
I will really appreciate your help
i'm using excel 2010
i have a simple userform with 3 textboxes, to enter data to table.
textbox1=part number
textbox2=qty
textbox3=amount of labels
in the third box i want the user to specify how many rows he wants to copy the data in textbox1 & textbox2. All the 3 textboxes accept only numbers.
basically i'm looking for somthing like the code in KB called "Copying & Inserting Rows" by dazwm.
My target in the end is to create table of labels and to use mail merge in Word Application.
I will really appreciate your help