Results 1 to 6 of 6

Find number, change background colour, loop.

Threaded View

  1. #1
    Registered User
    Join Date
    11-08-2011
    Location
    canberra
    MS-Off Ver
    Excel 2003
    Posts
    3

    Find number, change background colour, loop.

    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!
    Last edited by rjtedge; 11-09-2011 at 07:52 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1