Find number, change background colour, loop.

[rjtedge]

Hi all,

I'm just getting started with macros and have so far been able to search for all of my solutions. However I seem to be stuck.

I am looking for a macro that will
1. open a search box
2. i entre text and click search
3. if a match is found the background colour is changed
4. a new search box open.
5. repeat until i click cancel.

Is this possible and if so any suggestions for code?

Thanks heaps!

[NickyC]

Hi
try this

Please Login or Register  to view this content.

[rjtedge]

Hey,

I'm not sure what is happening, but when I try to run the code nothing seems to happen after the search box opening.

When i click seach another search opens without changing anything?

I have both text and numbers, would this effect it?

[NickyC]

My apologies, I made an error in the code
try this:

Please Login or Register  to view this content.

[rjtedge]

Wow, that is perfect!!

Thank you so much, everything i had tried was much larger.

[Leith Ross]

Hello rjtedge,

Welcome to the Forum!

You posted this same question here. We ask that you let us know if you have posted your question elsewhere. This prevents solutions from being duplicated and time from being wasted answering questions that have answers.

As a new member, please take some time to familiarize yourself with the rules.
Forum Rules