Jodeyarce
11-01-2011, 06:09 AM
Hi peeps,
Is there a way to automatically input a list of data using Userform?
For example,
I will have 2 input textboxes:
1. Job Number
2. No. of Shirts
When i enter Job Number 1 and for e.g. 4 no. of shirts, I am hoping the VBA will automatically insert the data into:
Column A
(Job No.)
1 (Cell A1)
Column B
(Shirt No.)
1 (Cell B1)
2 (Cell B2)
3 (Cell B3)
4 (Cell B4)
Also, if i continue with a 2nd Job, the shirt number will reflect continuously (e.g. Userform Job No.=2 & No.of Shirts=3),i.e.
Column A
(Job No.)
1 (Cell A1)
2 (Cell A4)
Column B
(Shirt No.)
1 (Cell B1)
2 (Cell B2)
3 (Cell B3)
4 (Cell B4)
5 (Cell B5)
6 (Cell B6)
7 (Cell B7)
Thanks in advance! :)
Is there a way to automatically input a list of data using Userform?
For example,
I will have 2 input textboxes:
1. Job Number
2. No. of Shirts
When i enter Job Number 1 and for e.g. 4 no. of shirts, I am hoping the VBA will automatically insert the data into:
Column A
(Job No.)
1 (Cell A1)
Column B
(Shirt No.)
1 (Cell B1)
2 (Cell B2)
3 (Cell B3)
4 (Cell B4)
Also, if i continue with a 2nd Job, the shirt number will reflect continuously (e.g. Userform Job No.=2 & No.of Shirts=3),i.e.
Column A
(Job No.)
1 (Cell A1)
2 (Cell A4)
Column B
(Shirt No.)
1 (Cell B1)
2 (Cell B2)
3 (Cell B3)
4 (Cell B4)
5 (Cell B5)
6 (Cell B6)
7 (Cell B7)
Thanks in advance! :)