User types into user form and information is pulled from the sheet to the userform

I have a user form in which I would like the user to enter the "X shrinkage" and Y shrinkage and the "hole arrangement". These should be drop down boxes where the choices are 8.00 to 26.00. I would also like the user to be able to type in the shrinkage if possible. These values should be used for the calculation, this is currently cell H2 and I2, (15.5).

When the user types in the hole arrangement, i need a table to return in the form where all matches from column A and the corresponding row is in the table. For example, the user enters 19-11 for the hole arrangement. The return in the form is A37-F47.

Help please!
CAD_LAYOUT_BUILDER1.xlsm

@davesexcel

I'd load the UF like this because of the number of rows to be checked.

Please Login or Register  to view this content.

Your code loads the UF in 2.1 sec, mine in 0.03 sec

@sdl2
You say you want 2 comboboxes with choices 8.00 to 26.00, but in what sequence do you want them.

The second part of your question i have adapted in your userform. By selecting a hole arrangement the filtered list appears in listbox1.

Originally Posted by bakerman2

@sdl2
You say you want 2 comboboxes with choices 8.00 to 26.00, but in what sequence do you want them.

The second part of your question i have adapted in your userform. By selecting a hole arrangement the filtered list appears in listbox1.

Hi bakerman2,
Thank you for the response, you have the right idea with the user from. What I need is for the X shrinkage and Y shrinkage to be drop down boxes, 8-26 8.1, 8.2, 8.3 etc. Then when the user selects the shrinkage for the X and Y, column F would show up in the "Step and Repeat" box. Column F has dependence on H2 and I2, the X shrinkage and Y shrinkage.

Please Login or Register  to view this content.

column F would show up in the "Step and Repeat" box. Column F has dependence on H2 and I2, the X shrinkage and Y.

This I don't get. Do you want the entire column in the box or a filtered list based on shrinkage ? If Yes, how is the list to be filtered. Please include example to explain filterciteria.