Reduce a vba script

[tigerdel]

Good Morning All

I have a script that populates various textboxes and comboboxes on a UserForm from an excel spreadsheet.

There are 72 various fields that get populated depending on the content of another textbox on the USerForm.

I have attached one of the scripts and a screenshot of the UserForm.

I am currently about half way through writing the necessary scripts and have reached page 44

I am wondering if it is possible to reduce the script dramatically or am I going about it correctly??

Your expertise and advice is gratefully received as always

Main_Screen.docxPublic Sub ERM.docx

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic