Excel is a great tool with lots of features, ranging from creating random numbers to being able to perform a continuous search.
And, when you have a page that is too long, with a large amount of information, it is useful to be able to use a shortcut and find something among all that.
Plus, it’s so much better when you can keep searching without having to enter the command over and over in Excel.
This makes your work much easier, so it is a relief that this spreadsheet has functions that help you find any data more quickly.
VBA macros
The methods to perform a continuous search require a certain ” Programming ” that can only be understood by reading the Excel workbook.
Or, you could take a content course, which can be done at the following link, where they have a whole library of material.
This will help you to code or code in the VBA to build and create a macro that will allow you to use smart search methods. VBA is an object-oriented programming language in Excel, whose acronym stands for Visual Basic for Application, which has many uses and properties.
Thus, to enter it, within the program you have to go to the ” Developer ” tab, an action that will unlock a series of choices.
On the left side of that segment, there will be an option called ” Visual basic ” which must be clicked to continue.
There, a new window will open within the same spreadsheet, in which there will be a left location element and a blank screen.
To continue, you must choose the file or document name from the aforementioned bar, and write the macro in the empty part in the middle.
In this place, you can build the code you need depending on the case, or it can be taken from an example template from the internet.
With the condition that it is necessary to ensure that the example found meets the needs of the user so that there are no errors.
Use only the Find method
In this part of the guide, you will only run the Find method before configuring and running a continuous search in Excel.
Once the macro has been adjusted within the VBA of the spreadsheet, it will be possible to proceed with the simplest procedure.
It is then that you have to go to the ” Developer ” tab again, and identify a button with the name ” Macros “.
Clicking on it will display a list of all items of this nature added to the existing spreadsheet.
As you only have one, in this case, it is the one you are going to choose and click on ” Execute “, which will show a box where you can write. In this way, you write anything that can help to identify the value you want to find in Excel.
This can generate a series of reactions, which will depend on the configuration of the macro that has been placed on the sheet. In most cases, it results in the underlined value of some specific color.
Use the FindNext method to perform a continuous search
Thus, by means of this technique, it will be possible to carry out a continuous search to which the previous method has already executed.
In this way, when the macro is used, it will allow you to underline or select other values that may have a match with the first and the search suggestion.
It does this by saving the first choice or result found and, through a loop, continue to find more values.
To do this, you have to go back to the VBA editor and slightly modify the structure of the macro used to make the first medium.
Inside it, a conditional must be placed that says that as long as the value is similar to another, it must be taken in the same way. And another that makes the loop not continuous, and that the moment comes when, when there are no more coincidences, it must stop.
You can use macros in Excel for anything you want, whether for a simple task like copying and pasting cells or a more complex one like searching for words in a range or range of cells.