Macro To Pick a part number from selection

Hi

Im not sure if im thinking alone the right lines, but im hoping someone can help me out, Basically I have a "specification sheet" where a customer ticks the options they require which then after pressing the "Build" Button It unhides all the parts required. Ive cut down the options to the problem area, I need to be able to tick the reservoir box and tick only one or sometimes maybe none of the socket options boxes but when the build button is pressed i need the part number in the red box to change accordingly, Ive included a reference table so you can see the options & numbers. Can anyone help please?

Originally Posted by Denzil

Hi

Im not sure if im thinking alone the right lines, but im hoping someone can help me out, Basically I have a "specification sheet" where a customer ticks the options they require which then after pressing the "Build" Button It unhides all the parts required. Ive cut down the options to the problem area, I need to be able to tick the reservoir box and tick only one or sometimes maybe none of the socket options boxes but when the build button is pressed i need the part number in the red box to change accordingly, Ive included a reference table so you can see the options & numbers. Can anyone help please?

I can't open the workbook.......