1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

another excel query

Discussion in 'Business Applications' started by hermes, Jan 30, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. hermes

    hermes Thread Starter

    Joined:
    Aug 12, 2000
    Messages:
    642
    Hi

    After my last problem was generously sorted out I came up with another.

    Would it be possible to record a macro or use some vb to check my active worksheet for a defined condition (in this case, text that is coloured red) and display a message box telling me I have tasks still incomplete (as indicated by the red font).

    All clues welcome
     
  2. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
  3. hermes

    hermes Thread Starter

    Joined:
    Aug 12, 2000
    Messages:
    642
    Hi Dreamboat

    i tried out:

    If ActiveWindow.ActiveSheet.Range ("A1:A100").Value = "xxxxxx"

    This doesn't work. But i'm sure i'm close to it. I tried taking out ActiveWindow and a few other tweaks, but no joy.

    Should I try this one in programming, nobody seems to want to jump in?
     
  4. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    Nope. Stay here, or move to mine. Lotsa programmers there, 'specially Excel. www.theofficeexperts.com/forum/

    :)

    I might try:

    If ActiveWorkSheet.Range ("A1:A100").Value = "xxxxxx"
     
  5. MadDogMugsy

    MadDogMugsy Guest

    lol - may not be joing in, but have definately subscribed to this thread ... very interesting;)
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/116077

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice