Excel vba coding

[Johann Grech]

Hi there I have a problem with vba coding for searching in excel worksheet. My actual code works fine but it searches data from the begining of work sheet rows/cell to the end of work sheet rows/cell. I need to code that it start search from the last row entry to the top of the work sheet. Any help how to modify my code to perform the search from last entry please? this is my actual code:

Dim totRows As Long, i As Long

totRows = Worksheets("sheet1").Range("A1").CurrentRegion.Rows.Count

 If TextBox1.Text = "" Then
   MsgBox "Enter the File Number"
   End If
   
For i = 2 To totRows
        If Trim(Sheet1.Cells(i, 1) <> Trim(TextBox1.Text)) And i = totRows Then
           MsgBox "File Not Found!"
           End If

thanks

           
        If Trim(Sheet1.Cells(i, 1) = Trim(TextBox1.Text)) Then
           TextBox1.Text = Sheet1.Cells(i, 1)
           TextBox2.Text = Sheet1.Cells(i, 2)
           ComboBox1.SelText = Sheet1.Cells(i, 3)
           TextBox3.Text = Sheet1.Cells(i, 4)
           TextBox6.Text = Sheet1.Cells(i, 5)
           ComboBox3.SelText = Sheet1.Cells(i, 6)
           ComboBox2.SelText = Sheet1.Cells(i, 7)
           Exit For
      End If
Next i
     
    
End Sub

[Sam Capricci]

Johann, welcome to the forum, please check the forum rules, particularly #2 about posting code. Please edit your post to put code tags around the code. In the quick reply tab it shows as <> among the selections for html. Plus you might want to ask a moderator to move this to the VBA part of the forum. It should look like the below. (If I could help you I would but I don't have VBA skills.)

[torachan]

try changing

For i = 2 To totRows

to

For i = totRows to 2 step -1

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks

[Pepe Le Mokko]

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks