Hi everyone,
This has probably been answered somewhere but I cant seem to find exactly what I want.
I need a way to search an entire worksheet for a variable or part of a variable entered by the user. For example, lets say that the user enteres Ja. There would be entries in the sheet for say Jackson, Sonja, Jameson, etc. So the search would have to find the characters anywhere within the string.
You need to search for xlPart. Are you looking to return all found files? What are you looking to do with the result?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Hi Malcomb,
What I want to do is return all rows that match the partial string. The reason I need to do this is because our IT dept will not let me run my PHP app which works great on our server. So if you find "Ja" in 20 rows I would want to return all rows that meet the criteria in a VB form of some kind, something suitable for the net.
There would only be 4 columns to show, A,B,C,D. Thanks
Are you searching a particular column?
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
No the characters could appear anywhere on the sheet. Also, I can't find a resource but I would like the results to show on something like a browser window. That may be too much to ask though.
Austenr,
I don't know about the browser part but here is a filtering solution which copies the rows containing the string....uses inputbox and I used ja to test to sheet 2....Maybe it's a start for you.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Hey Steve. Thanks. That might work with the exception of 2 things. First hide the search data (very hidden). It should not be accessible to the user. Second, present the results in a VB form with column headings and the data underneath.
one at a time....maybe we can sort it...what do you mean by this:
Are you talking about the main sheet with the data and the button to run the code?First hide the search data (very hidden). It should not be accessible to the user.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
see how we're doing.....
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Doing fine. Now can the results be put into a VB form? With the buttons on the form that do the search and clear?
How do you wish to show it on the form? Listbox...?
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
see attached
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Hi Austen,
Is this solved?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Hi Malcomb. Yes it is. Sorry.
Posting Permissions
Reply With Quote
