Help to speed up code

I have a userform and based on the selections from the combobox selections the macro adds the data to the next blank row of the form.selected worksheet. The trouble is the few seconds it lags to do this. I had some code that did almost this same thing but instant, the problem was the information wasn't getting placed into the correct row of the sheet. This one does it correctly but a huge difference in the time it runs through the code. Any suggestions or help is greatly appreciate. Thanks in advance.

Please Login or Register  to view this content.

Thank you for the quick response. I tried your suggestion of turning off ScreenUpdating but got the same results. I think the issue is the Loop I have, which is searching for the first empty cell in column A after A13 to copy the users input to. Im sure there is a way to speed this part up I just don't know what it is... suggestion ?

Please Login or Register  to view this content.

Originally Posted by MarvinP

Hi saintsphan,

Here are some links:
http://www.cpearson.com/excel/optimize.htm
http://www.excelitems.com/2010/12/op...er-macros.html

Turning off ScreenUpdating is the easiest and recommended the most.

I don't recall why that was in there.. I removed it add added the screenupdating back in and its a bit faster.. Still not instant like the other code I had but maybe that code wasn't looping, hence why I changed it. Thanks for the guidance. Ill mark this as solved unless you can think of anything else. Thanks again.