I have a userform with a combobox and corresponding textbox. The user will select a code in the combobox and enter a number into the TextBox for that Code, Example: TextBox=5, ComboBox=BDE. I would then want the user to click "Save" button and the code would then look at a sheet in the workbook and search in the top row of the sheet for the ComboBox code "BDE" once it finds it it would then find the next empty row and place the TextBox data "5" on the empty row in the column corrisponding to the looked up value of BDE. I also have various other TextBoxes on this userform that need entry on the same empty row however their entry on the empty line is always going to be in the same position such as column A, B, C,to G. the lookup values start on column H:DX. So TextBox 1 through 7 will always be placed under column A-G, Textbox8 will vary depending upon ComboBox1's value and will be placed on either column H through DX. I have the code for the first 7 TextBoxes:

Please Login or Register  to view this content.
My issue is with the next Textbox that will depend upon the lookup value of the Combobox.

Thanks in advance for your help.