W
wuming
Hi all,
I have this program with a userform With a click of a command button i
the userform, i want program to prompt user using input box for no. o
criteria tables to create. (eg. in attchment>> LUTS)
After prompting for no. of LUTS to create, program would prompt fo
each LUTS no. of criteria in each LUT.
Eg: command button click:
inputbox: "Enter no. of LUT to create: " Eg. 3 in the attachment
then next:
inputbox: "Enter no. of criteria in LUT no. 1: " Eg. 5 in th
attachment
inputbox: "Enter criteria no. 1: " Eg. Tan
inputbox: "Enter criteria no. 2: " Eg. Joo
.....
.....
inputbox: "Enter criteria no. 5: " Eg. Lee
Then this will continue for the 2nd LUT:
inputbox: "Enter no. of criteria in LUT no. 2: " Eg. 4 in th
attachment
inputbox: "Enter criteria no. 1: " Eg. Alexander
.....
.....
inputbox: "Enter criteria no. 4: " Eg. Hoh
this will continue until all LUT and their criterias are created.
Anyone knows how to do this using vba??
This is really complicated for me for someone of my lvl. :/
pls see attachment for details. Thanks in advanced.
Abyss of the goa
Attachment filename: newsample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63522
I have this program with a userform With a click of a command button i
the userform, i want program to prompt user using input box for no. o
criteria tables to create. (eg. in attchment>> LUTS)
After prompting for no. of LUTS to create, program would prompt fo
each LUTS no. of criteria in each LUT.
Eg: command button click:
inputbox: "Enter no. of LUT to create: " Eg. 3 in the attachment
then next:
inputbox: "Enter no. of criteria in LUT no. 1: " Eg. 5 in th
attachment
inputbox: "Enter criteria no. 1: " Eg. Tan
inputbox: "Enter criteria no. 2: " Eg. Joo
.....
.....
inputbox: "Enter criteria no. 5: " Eg. Lee
Then this will continue for the 2nd LUT:
inputbox: "Enter no. of criteria in LUT no. 2: " Eg. 4 in th
attachment
inputbox: "Enter criteria no. 1: " Eg. Alexander
.....
.....
inputbox: "Enter criteria no. 4: " Eg. Hoh
this will continue until all LUT and their criterias are created.
Anyone knows how to do this using vba??
This is really complicated for me for someone of my lvl. :/
pls see attachment for details. Thanks in advanced.
Abyss of the goa
Attachment filename: newsample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63522