faster method for saving data from userform to worksheet

I have a userform and on the userform there is a save commandbutton. When I first began, the save method only took a couple of seconds. Now that I have over 600 records, it takes much longer. Just seeing if there is a more efficient quicker way to do this

HTML Code: 

thanks,

Josh

One thing that will speed your code up, is to stop using Select and Activate. Have a look at this silly example and see if it helps to get you going:

Please Login or Register  to view this content.

HTH

TJ

What is it that you are searching for "n" ?

You could save some time by not activating and selecting things.

Give this a try:

Please Login or Register  to view this content.

As your sheet grows it will still be slower but this should help.

Hello Josh_123456,

Based on your comment that after adding 600 records, I doubt this code fragment is slowing you down. The code only retrieves one find result per execution. So you probably are calling this from another loop. You should post your workbook so we can review all your code.

Sincerely,
Leith Ross

I finally got a chance to redo the coding for this.... and while testing, it worked great and was very fast... now it is very slow when it runs....

there are only 20 records.... any ideas

below is what I am currently using

HTML Code: 

thanks for any direction

Josh