Auto Filter With Input Box In VBA MS Excel
#VBA #Auto_Filter #input_Box
Auto Filter With Input Box In VBA MS-Excel| Inputbox In VBA| Input Box Use In VBA| VBA Tutorials
VBA Code:
a = InputBox("Enter the Criteria")
With Sheets("Data")
.Range("A1").Select
.Range(ActiveCell, Selection.End(xlDown)).Select
.Range(Selection, Selection.End(xlToRight)).Select
End With
Selection.AutoFilter field:=1, Criteria1:=a
Attitude Academy
Find out more about Attitude Academy and our programmes at
https://www.attitudetallyacademy.com/
Our Social Platform
⏩Youtube Channel
/ attitudeaca. .
⏩Facebook Page
/ attitude2edu
⏩Website
https://www.attitudetallyacademy.com/
⏩Instagram
/ attitudeaca. .