Yes, ladies and gentlemen Excel in today's Excel article, I will share a tip Create search box on Excel file, unlike the way to look up values in VLOOKUP, HLOOKUP and INDEX, MATCH is quite cumbersome in formulas and values, arguments.
With From this search, you just need to type the syntax for Excel to automatically search for absolute and relative values similar to the Google Search tool. Support you to filter and search the desired values on long spreadsheets more easily and quickly.
Instructions to create From search on Excel file
+ Step 1: First, open your Excel file. Here you click the title box of the values to create a search => and open the tab
Insert => select
Then tick the selection
My table has headers => and click the box
OK to create a filter for the spreadsheet.
+ Step 2: Now open the tab
Design up => and choose the color you want to create for the spreadsheet.
You click open tab
Fomulas => and select
Name Manager appears, click on it
Edit... as shown below.
+ Step 3: In this step, please name the selection of the Sheet in the box
Name => Then press
OK to create.
Close to exit.
+ Step 4: Next you open the Developer tab => select
Insert => and continue to choose
Text Box (ActiveX Control) => And create
From from the umbrella A2 to B2.
+ Step 5: Then right click
From => select
The dialog box appears
Properties Text Box => here you enter
LinkedCell is the umbrella
A2 to create a link to spreadsheet => and then press (
x) to exit.
Note: Please replace A2 equal to the value that matches your Excel table.
Then right click
Text Box => select
View Code to open the VBA program.
+ Step 6: At the dialog box
Sheet (Code), you place the mouse pointer over the part
End Sub as the following picture.
Then copy the following code (the places in red are necessary to replace to fit your board):
ActiveSheet.ListObjects ("HVT“) .Range.AutoFilter Field: = 1, _
Criteria1: = "*" & (A2) & "*", Operator: = xlFilterValues
+ Step 7: Paste in the middle => then change the parameters:
- Name Table at section
- And umbrella Cells set in
=> Then turn off the dialog box
Microsoft Visual Basic for Applications.
Now change the color of the cells in the Text Box.
+ Step 8: Finally click on
Design Mode in the tab
Developer to activate the search box.
And enter the characters in the Text Box box to try it out.
Test play again ....
Okay so that's it, I have just guided you How to create a Search word in an Excel file a fairly detailed and easy way, support for searching and filtering information in a super fast way already.
This is extremely useful for Excel files with lots of data. Yes, and here my article would like to pause. Hope this tip will be helpful to you.
Good luck !
CTV: Luong Trung - Blogchiasekienthuc.com
Note: Was this article helpful to you? Do not forget to rate the article, like and share it with your friends and relatives!