PDA

View Full Version : userform with option to Copying & Inserting Rows



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