Help writing case with case or loop within loop based on 1 cell value and user input

Hello,
I have tried to write out the code or at least the steps. Its mostly how to write this code and pass variables. I have a value 1-9 on sheet 6 range e19 this is the case value. case 1 is "green circular"
I have a message box from the user asking the user to specify a part number also 1-10. I need to read sheet 6, e19 value to select the case and then user input to select the case within the case. Then from the user input value 1-10 i need to pass the variable to the userform textbox, 'UserForm1.KeyDia& number & .Value UserForm1.KeyDia6.Value for example. Then at the end I need to copy the case and user input value to the corresponding cells on sheet2, clear the contents of sheet1 A:C and promt the user for a new part or to exit.

Thanks for the help!

Please Login or Register  to view this content.