Is there a way to make the text blink on and off using Excel VB?

[Guest]

I'd like to highlight various anomalies in text field content, by making the
text in them blink (disappear/reappear programatically).

Can it be done?

 

[Ron Coderre]

Chip Pearson covers that topic:
http://www.cpearson.com/excel/BlinkingText.htm

I hope that helps.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

 

[Guest]

http://www.cpearson.com/excel/BlinkingText.aspx

 

[Guest]

Help! When I use this macro it stops working if I protect the worksheet. This
message comes up: "Unable to set the color index property of the font class."
Is there a way around this?

 

[Chip Pearson]

You need to unprotect the sheet or protect it with the UserInterfaceOnly
setting as True:


Worksheets("Sheet1").Protect Password:="MyPassword", UserInterfaceOnly:=True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[sansk_23]

Hi !! Did as suggested in the link below .
When i try to close the worksheet , it gives me an error : -
Compile Error. "Startblink" Sub or Function Not Defined.
If you could pls help me thru this .
rgds
Sk.