PDA

View Full Version : Cell Blink Macro



rajkumar
09-09-2008, 07:31 AM
Hi everyone,

I just checked cell blink macro in KB. it is wonderful.

I have a slight different requirement in that.

I want the entire row to blink if the pending days is greater than or equal to 10 days as per the pending days column in the Inventroy-Blr Worksheet.

I tried to modify the code and end up with error.

Please help.. :think:

Raj

Bob Phillips
09-09-2008, 07:46 AM
If it is so wonderful, and how can a cell blinking macro be anything other than annoying, how come it doesn't even work?

Kenneth Hobs
09-09-2008, 09:12 AM
The xls in the KB Article, http://vbaexpress.com/kb/getarticle.php?kb_id=891 (http://vbaexpress.com/forum/../kb/getarticle.php?kb_id=891), does work.

I would agree with xld though. Blinking like that is sure to annoy. However, if you still want help with it, post back.

I would use a Filter to show that kind of thing myself.

Bob Phillips
09-09-2008, 09:15 AM
The xls in the KB Article, http://vbaexpress.com/kb/getarticle.php?kb_id=891 (http://vbaexpress.com/forum/../kb/getarticle.php?kb_id=891), does work.

I meant his workbook is not working, I never even loot at the article. Re-reading it though I guess he has posted the amended, non-working version.

rajkumar
09-09-2008, 11:39 AM
That's Fine.

no Help required