I require a change the use to another database. Having 3 columns A to C. A required to increment the number by one, ie row 1 to 60 exist the next input to A to auto add next row to 61, then I add info to B & C.
THE CODE BELOW BY JERRY WORKS GREAT
Private Sub cmdFind_Click()
'search for searchText and populate list box with all data found
Dim searchText As String, FirstAddr As String
Dim FoundCell As Range, LastCell As Range, searchRange As Range
Dim i As Long, endRow As Long
Dim foundTarget As Boolean