Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA: Create new conditions
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 -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a formula with multiple (IF) conditions | Excel Discussion (Misc queries) | |||
Can I create more than 3 Condidtional Format conditions or can I w | Excel Worksheet Functions | |||
Create a formula with conditions | Excel Worksheet Functions | |||
How to create a formula that meets 2 different conditions... | Excel Discussion (Misc queries) | |||
How do I create a formula that has circular conditions? | Excel Discussion (Misc queries) |