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.

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.

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

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


.

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


.

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