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:

Sub doit()

Dim rngFound As Range

With Sheet1.Columns("A")
    
    Set rngFound = .Find(what:=3)
    
    If Not rngFound Is Nothing Then
        rngFound.Offset(0, 1).Value = "Hello"
    Else
        MsgBox ("Not Found")
    End If

End With

End Sub

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:

            With Worksheets(shData)
             x = .Columns("F").Find(n, , xlFormulas, xlPart, xlByRows, xlNext, False, False).Row
            
                .Cells(x, 6) = txtCompany
                .Cells(x, 2) = CDbl(txtCAN)
                .Cells(x, 7) = txtContact
                .Cells(x, 3) = Format(txtPhone, "[<=9999999](###) ###-####")
                .Cells(x, 4) = Format(txtFax, "[<=9999999](###) ###-####")
                .Cells(x, 5) = txtEmail
                .Cells(x, 32) = txtNotes
                .Cells(x, 23) = cbxPackage
            End With
            
        shHome.Activate
        
        MsgBox "Done"
        
        Application.ScreenUpdating = True

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