Making Calls with Macros
An Excel file that teaches how to perform Searching with Macros operation.
Excel Format: Making Calls with Macros
The search value is retrieved via InputBox or UserForm. Searches are made in multiple columns. Matching lines are colored. If it is not found, an informative message is given. The solution is a practical tool for large tables.
Hope it is useful.