ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Make a cell blink (https://www.excelbanter.com/excel-discussion-misc-queries/23004-make-cell-blink.html)

JenML5

Make a cell blink
 
Hi there -
I need a cell to "blink" or change back and forth from one color to another
when a workbook is opened. I tried to do this with a macro, but when you run
it, it goes so fast that you cannot see it blink.

Any ideas on how to do this??
Thank you,
Jen

papou

Hi
You may use Sleep to control the blinking speed together with DoEvents.
HTH
Cordially
Pascal

"JenML5" a écrit dans le message de news:
...
Hi there -
I need a cell to "blink" or change back and forth from one color to
another
when a workbook is opened. I tried to do this with a macro, but when you
run
it, it goes so fast that you cannot see it blink.

Any ideas on how to do this??
Thank you,
Jen





All times are GMT +1. The time now is 09:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com