Find is the string we want the user we want to enter to search. How to use an Excel 4 Macro. For locating case-insensitive matches take a look at the SEARCH function.
Dim Rng As Range.
Add a comment. The Msg Box method. In addition to calling a function from your VBA code using a sub procedure you can also call the function from within your Excel sheet. Learn the following key concepts of the FIND command.