Hi,
I'm trying to create a form which displays product info depending on the requirements selected.
i've tried using data dependant lists so that you could select the options and the list would change depending on the selection but had trouble using more than 2 data dependant lists. i need 4 min.
i then tried using a form with vba code from lists on another worksheet. you would click on the form button and it displays a box with 4 boxes in it. then you can select the options and excel will populate the columns with the data. however the layout is not quite right yet.
what would be ideal is if the user could click on a button and a form box would appear with the first selection of options then once selected the user clicks ok and depending on the selection, a second box appear's with the next set of options to select. there would need to be 4 of these boxes. then once all the data is selected it would display on the excel sheet with extra detail's on the product selected.
any idea's?
I'm trying to create a form which displays product info depending on the requirements selected.
i've tried using data dependant lists so that you could select the options and the list would change depending on the selection but had trouble using more than 2 data dependant lists. i need 4 min.
i then tried using a form with vba code from lists on another worksheet. you would click on the form button and it displays a box with 4 boxes in it. then you can select the options and excel will populate the columns with the data. however the layout is not quite right yet.
what would be ideal is if the user could click on a button and a form box would appear with the first selection of options then once selected the user clicks ok and depending on the selection, a second box appear's with the next set of options to select. there would need to be 4 of these boxes. then once all the data is selected it would display on the excel sheet with extra detail's on the product selected.
any idea's?
