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.......

Originally Posted by Denzil

---bump--- Can anyone Help please??

Many Thanks in advance

Denzil

Hi Denzil,
Sorry for not responding, I was hoping somebody else would, I have looked at the workbook a few times, it just seems like a lot of work the way you have it set up, I can't see it even being filterable without spending a lot of time on it to make it happen....