How to Create Excel VBA Data Entry Form With Search Function using Userform. In this tutorial, you will learn how to search the database, write For Loop and, selection Statement functions.
========================================================
Correct Code for Delete:
Dim i As Integer
For i = 1 To Range(“A65356”).End(xlUp).Row - 1
If lstDisplay.Selected(i) Then
Rows(i + 1).Select
Selection.Delete
End If
Next i
=======================================
See the correct code for the search function:
Change
For i = 10 To iSearch
To
For i = 1 To iSearch
Subscribe: https://www.youtube.com/channel/UCFtw9CfTfMKU9aHZsT2teYg
#excel-vba