Hi Forum,

After adding some additional code to a change procedure on a userform, I'm getting a "Compile Error: Procedure too large". I realize this is due to the single procedure exceeding the 64kb size limit, however I'm unsure what the best way to split apart the procedure or reduce redundancy within the procedure to reduce the size. The procedure code in question is attached below as a .docx (due to the size of the procedure). Basically I have a dropdown list containing study ID's. Based on what is chosen in the dropdown list, the rest of the variables throughout the userform are populated with the corresponding data. Please let me know if you have any suggestions! Thanks!!

cboStudyID_Change().docx