another excel query

[hermes]

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

 

[Anne Troy]

1. I put your "add worksheet" code on my web at:

http://www.theofficeexperts.com/VBASamples/Excel03.htm

One of my coders is going to "perfect it" soon, so look for that change.

2. Start here for your colored font:

http://www.cpearson.com/excel/colors.htm

You can't record the macro, but we could get you started by doing an IF in VBA, like IF cells A1:IV65536 contain red font color, then go to the first one....

 

[hermes]

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?

 

[Anne Troy]

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"

 

[MadDogMugsy]

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