I think I've figured it out but I was wondering if you guys could help me in cleaning up the code. I have created a sample workbook that does what I need, but i would like to improve the look/efficiency of the code in the update button and the Combo box change:
Command Button Update
Combo Box
As you can see the code is a little long as it is and only has 3 drop down options and 3 text boxes (my original file has 20 drop down options and about 44 text boxes!!!). I was hoping someone could help me almost write a VLOOKUP or Index statement to check the year in the combobox and copy all the text into the corresponding column.
Thanks again for your help!
Bookmarks