Скачать или смотреть Create a Filter as You Type SEARCH BOX in Excel VBA

📽️In this video, I explain how to use VBA code in Excel to automatically lock a cell after a value is entered. The value then can't be changed unless you unprotect the sheet again. This Excel VBA project uses VBA code to lock cells.

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted...
Thank you! 👍👍

Here's the code:
Private Sub optBeginsWith_Click()
Call txtSearchBox_Change
End Sub

Private Sub optContains_Click()
Call txtSearchBox_Change
End Sub

Private Sub txtSearchBox_Change()
If optBeginsWith Then
ListObjects("SalesRepsVBA").Range.AutoFilter Field:=1, Criteria1:=Range("B1") & "*"
Else
ListObjects("SalesRepsVBA").Range.AutoFilter Field:=1, Criteria1:="*" & Range("B1") & "*"
End If
End Sub
------------------------