Flashing Text

[Jakeuk]

Hi
is there a way of making the text in a cell flash or blink, the text within the cell is controlled by an IF condition, its a prompt to highlite the entry field for information.
Thanks
Jason

 

[steve case]

Thank you every one, I browse this site quite often for gems like this.

I'm quite the newby, and this thread taught me how to use worksheet macros.
I'm now more dangerous than I was five minutes ago! <blink></blink>

 

[KarenMulder]

VBA ok, tot zo ver was ik al. Maar dan "code Module" waar moet ik dat zoeken?

 

[Sourdust]

A mistake

 

[yankee428]

I pasted the code into a module, but how do i run it F5 from VBE or Alt+F8 from XL not showing any macros to run??? Is there a different technique with Private Sub Procedures???

 

[Zack Barresse]

hello, use the code from 'gottimd' on page one of this post. adjust ranges/colors to suit. do not paste into a module, rather paste all in your worksheet (i.e. right click sheet name -> View Code -> paste in right frame).

hth

edit: typo