Hi, i have a sheet with a large many rows of data. I would like to have a macro button to open a pop up msgbox so I can enter the data i am looking for and have matching cell selected.
Its basically a find function run from a macro but as soon as the search detail is entered the cell will be highlighted.
I have searched for this as I am sure it must be commonly used but unable to find a simple solution.
All help appreciated.
"as soon as the search detail is entered the cell will be highlighted" You have to have an additional user action to indicate the search detail is ready to search, like a Search button.
How is this different than hitting CTRL-f?
Once I had the basic macro I would develop it further to perhaps hi-light the data of interest within the found row.Originally Posted by 6StringJazzer
To look for a partial match, change xlWhole to xlPart.
To look in formulas and values instead of just values, change xlValues to xlFormulas.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks