HI I have below working code delivered by HA HO BE and it works great. But sometimes I need to search for more numbers. So if possible could some have a look if its possible in inputbox 2 to also type more than one example customer nr. , separated by comma and it will find them all.
Example like this 00021366,00041568,000258789
Please have a look at the code if this could be possible.
Thanks in advance
Sincerely
Abjac
Please Login or Register to view this content.
This doesn't use commas, it simply loops so you can search as many times as you want. Give it a try. One search at a time:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi Jb. Just tried it now. I see the idea. But it give me a objectvariable or with block variable not set error the second time i search.
IN this line.
Please have a look its important i dont have to put in the search sheet again. But i think thats ok
Have a look please.
Sincerely
Abjac
this line have error
Please Login or Register to view this content.
1) try removing that line completely from where it is
2) Put this tweaked version up higher:
Please Login or Register to view this content.
HI I tried what you say it did not change anything. What ever i move higher up also. It still give and error.
Thanks
Abjac
Time to post the workbook with macro in it so I can do real testing.
HI JB ok here is the test workbook to search in and macro in module1
Forgot to say it search in column C and also in P. And it have to be full match. I will mostly use the multi search from column C
and here its a search with 8 digits
Have a look thanks
Sincerely
Abjac
Last edited by abjac; 09-11-2014 at 03:47 PM.
Here you go:
Please Login or Register to view this content.
Hi. JB. Yes just tested it not it works like a charm. Its exactly how it should work. Thanks allot for your effort.
And have a nice day.
Sincerely
Abjac
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks