How to streamline userform coding for faster run time.

Hello,

I made a userform that allows a person to input a Carrier#/Color/Size/Part# and save it to an excel table. I have it setup to where the person running the code is unable to access the data table or make changes to it, it also saves the excel sheet after each input is submitted. On my laptop the form runs fine, but when I place it on the operators computer; it is laggy and slow to run and will show "Not Responding" due to the load times between submissions.

I have ScreenUpdating set to False but it did not help. I attached the excel sheet, I am not sure what can be done to make the code more efficient.


Any advice would by great! Thanks!