Hi all,
I'm tring to implement some code which will find and highlight cells which contain "#MULTIVALUE" in any and all tabs within a spreadsheet. The #MULTIVALUE is just plain text and not a formula generated error, if that makes any difference as the report has been pasted special values.
Last edited by Gti182; 11-15-2010 at 08:41 AM.
Found some code i can use but i need to edit it to apply to an entire workbook and not just the active sheet.
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by StephenR; 11-15-2010 at 07:53 AM.
That works a treat StephenR.
Was wondering if it's possible to autofill the searchbox with the "#MULTIVALUE" text instead of having to type it in?
Replace:
Please Login or Register to view this content.
with:
Please Login or Register to view this content.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
In practice you're better off searching just the range of actual values rather than the whole sheet.
thanks for the feedback everyone.
TMShucks i see what you have done there. I still would like to keep the searchbox option for general searches if that is required by the user. I was just wondering if the macro is run, instead of having to manually type in "#MULTIVALUE" if it could already be in the search field before i actually click the search button?
Please Login or Register to view this content.
Regards
ah thats brilliant! cheers everybody
You're welcome. Thanks for the feedback.
why not use find replace ?
you should be able to select all sheets find #MULTIVALUE replace all with #MULTIVALUE and also replace the format
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I would like to do something similar to this. I am new to macros and VBA.
My questions are:
Is this code entered for a ActiveX command button?
Do I need an additional box to enter the text to search for? Is this entered in a cell or an ActiveX text box?
My sheet is Sheet1 and I would like to search column B for the desired text.
I would like the user to enter a value (in a cell or text box), click the command button and have it find and highlight the desired row.
Thank you
I'm trying to find and highlight a number of words but for some reason it only finds the last word ie "Bad". Any ideas?
Please Login or Register to view this content.
What you have is a list of variable assignments and you are just overwriting the previous value of Fnd with the next, hence you end up with "Bad"
You probably need to define Fnd as and array and put the entries in the array. You'd then have to loop through the array to check each value.
You'd maybe have done better to start a new thread and cross refer to this one. As it's marked solved, some people may not notice it ... because I responded to the original thread, I am subscribed to it so see the updates.
Regards
I have trying to do this same thing, but instead of highlighting, I want to search for a word, select it, and select everything in the column below it.
Its for a graph and the data chages columns so I need to search the "Name" in the cells instead of "A1"
THanks
@boarder236: asking a question in someone else's thread is considered hijacking.
Please start a new thread and, if you feel it is appropriate, insert a link to this thread.
Regards, TMS
Thanks TMS,
Boarder236,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Using VBA Code, I want to create a Search button that finds what is written in textbox.1 and I can select the file type from the listbox.1. On top of this, I want all the results to be highlighted once I click the search button. What is the code that I should use? Please help. Thank you.
May Badua,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
@iekika13: you'll need to PM a moderator or administrator. Arlu1201, for example, is an administrator.
Regards, TMS
Thanks TMS.
Iekika13,
I have removed your posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks