Create Searchbox Using Filter Function Automatically @Exceltrainingvideos
Create Searchbox Using Filter Function Automatically  @Exceltrainingvideos
Uploaded February 2020 | Updated November 2026, 1 day ago
How to create a searchbox using the Filter function automatically.
Here's the complete and cleaned recorded macro for automating the process:
Option Explicit

Sub searchbox()
'
' searchbox Macro
' Searchable Drop Down List

Worksheets("ClientNames").Range("C2") = _
"=FILTER(Table1,ISNUMBER(SEARCH(DataEntry!B2,Table1,1)),"""")"
Sheets("DataEntry").Select
Range("B2").Select
Selection.ClearContents
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=ClientNames!$C$2#"
.IgnoreBlank = True
.InCellDropdown = True
' .InputTitle = ""
' .ErrorTitle = ""
'.InputMessage = ""
'.ErrorMessage = ""
.ShowInput = True
.ShowError = False
End With

End Sub
This link may also be helpful: exceltrainingvideos.com/search-multiple-values-in-worksheet-data
Create Searchbox Using Filter Function AutomaticallyUser-form to Manage Data AutomaticallyHow to move from one control to another in a form on worksheetAutomate Copying of Master Worksheet || 2021Extract Data from Word Document Using Word and Excel VBACalendar Control for All Office versionsFilter Data into Listbox using two Combo-boxes data as CriteriaAutomatically Pop-Up Find Dialog BoxSort Worksheet Tabs By ColorGenerate Random Strings in Excel with VBADisplay Data in Listbox based on Combo Box SelectionCreate Floating Button
Dinesh Kumar Takyar |

Create Searchbox Using Filter Function Automatically

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER