Flashing Cell
 

I am looking for away to make an Excel worksheet cell
flash to draw attention to it when a particular number
results from a formula in the cell.

Flashing Cell
 

search on Flash, blink, cell

http://groups.google.com/advanced_group_search?hl=en

group microsoft.public.excel.programming

--
Regards,
Tom Ogilvy


"HRH" wrote in message
...
I am looking for away to make an Excel worksheet cell
flash to draw attention to it when a particular number
results from a formula in the cell.

Flashing Cell
 

Hi,

making the cell flash requires vba, and can greatly reduce the workbook's
performance. I'd recommend using conditional formatting instead, to change
the cell's font and/or background to something that stands out.

Cheers

"HRH" wrote in message
...
I am looking for away to make an Excel worksheet cell
flash to draw attention to it when a particular number
results from a formula in the cell.




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.736 / Virus Database: 490 - Release Date: 9/08/2004

Flashing Cell
 

I use VBA each time I record a macro and or go in and edit
a macro. Is there some type of pause command I can use in
between formatting a cell in a macro (i.e. bold=true,
bold=false, bold=true ..... so forth)

Thanks
HRH
-----Original Message-----
Hi,

making the cell flash requires vba, and can greatly reduce
the workbook's
performance. I'd recommend using conditional formatting
instead, to change
the cell's font and/or background to something that stands
out.

Cheers

"HRH" wrote in message
...
I am looking for away to make an Excel worksheet cell
flash to draw attention to it when a particular number
results from a formula in the cell.




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.736 / Virus Database: 490 - Release Date:
9/08/2004


.

Flashing Cell
 

See the wait command.

--
Regards,
Tom Ogilvy

"HRH" wrote in message
...
I use VBA each time I record a macro and or go in and edit
a macro. Is there some type of pause command I can use in
between formatting a cell in a macro (i.e. bold=true,
bold=false, bold=true ..... so forth)

Thanks
HRH
-----Original Message-----
Hi,

making the cell flash requires vba, and can greatly reduce
the workbook's
performance. I'd recommend using conditional formatting
instead, to change
the cell's font and/or background to something that stands
out.

Cheers

"HRH" wrote in message
...
I am looking for away to make an Excel worksheet cell
flash to draw attention to it when a particular number
results from a formula in the cell.




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.736 / Virus Database: 490 - Release Date:
9/08/2004


.

Flashing Cell
 

Hi HRH, you can use this code to flash the text as many times
as you want...just change the word 'look' to your needs...

Public Sub fla****()
ActiveSheet.Cells(1, 1) = "look"
Application.Wait (Now + TimeValue("0:00:01"))
ActiveSheet.Cells(1, 1) = ""
Application.Wait (Now + TimeValue("0:00:01"))
ActiveSheet.Cells(1, 1) = "look"
Application.Wait (Now + TimeValue("0:00:01"))
ActiveSheet.Cells(1, 1) = ""
Application.Wait (Now + TimeValue("0:00:01"))
ActiveSheet.Cells(1, 1) = "look"
Application.Wait (Now + TimeValue("0:00:01"))
ActiveSheet.Cells(1, 1) = ""
Application.Wait (Now + TimeValue("0:00:01"))
ActiveSheet.Cells(1, 1) = "look"
Application.Wait (Now + TimeValue("0:00:01"))
ActiveSheet.Cells(1, 1) = ""
Application.Wait (Now + TimeValue("0:00:01"))
ActiveSheet.Cells(1, 1) = "look"
Application.Wait (Now + TimeValue("0:00:01"))
End Sub

seeya ste