Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I MAKE A CELL OR WORD FLASH IN EXCEL?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I MAKE A CELL OR WORD FLASH IN EXCEL?
hi, Elie !
there is a wise-tricky procedure [posted by KL in spanish ng sometime ago]... [and with minor changes based on Thomas Jansen -1999- post]... that let's you to preserve the undo-levels, and you might want to give it a try... if any doudbts [or further information]... would you please comment ? hth, hector. assuming 'a cell' es [B1] and you need it to 'flash' if it's value is greater than 5 1) select 'B1'... - [menu] format / conditional format... [formula]: - =(b15)*(mod(second(now()),2)=0) [format]: - apply formats as needed/wished/... 2) copy/paste the following code-lines: === a) in a general code module: === Option Private Module Public Sequence As Date Sub StartBlinking() Sequence = Now + TimeSerial(0, 0, 1) Worksheets(1).Range("b1").Calculate ' modify/adapt/... worksheet's index/name as appropriate Application.OnTime Sequence, "StartBlinking" End Sub Sub StopBlinking() On Error Resume Next Application.OnTime Sequence, "StartBlinking", Schedule:=False End Sub === b) in 'ThisWorkbook' code module: === Private Sub Workbook_Open() StartBlinking End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) StopBlinking End Sub |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I MAKE A CELL OR WORD FLASH IN EXCEL?
Hector, Elie might also be interested in the solution provided over at this
site: http://www.cpearson.com/excel/BlinkingText.htm "Héctor Miguel" wrote: hi, Elie ! there is a wise-tricky procedure [posted by KL in spanish ng sometime ago]... [and with minor changes based on Thomas Jansen -1999- post]... that let's you to preserve the undo-levels, and you might want to give it a try... if any doudbts [or further information]... would you please comment ? hth, hector. assuming 'a cell' es [B1] and you need it to 'flash' if it's value is greater than 5 1) select 'B1'... - [menu] format / conditional format... [formula]: - =(b15)*(mod(second(now()),2)=0) [format]: - apply formats as needed/wished/... 2) copy/paste the following code-lines: === a) in a general code module: === Option Private Module Public Sequence As Date Sub StartBlinking() Sequence = Now + TimeSerial(0, 0, 1) Worksheets(1).Range("b1").Calculate ' modify/adapt/... worksheet's index/name as appropriate Application.OnTime Sequence, "StartBlinking" End Sub Sub StopBlinking() On Error Resume Next Application.OnTime Sequence, "StartBlinking", Schedule:=False End Sub === b) in 'ThisWorkbook' code module: === Private Sub Workbook_Open() StartBlinking End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) StopBlinking End Sub |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I MAKE A CELL OR WORD FLASH IN EXCEL?
hi, JLatham !
... Elie might also be interested in the solution provided over at this site: http://www.cpearson.com/excel/BlinkingText.htm I agree, it's one of my favorites :)) the only [dis]advantage between one or another, I gues is this part... -?- that let's you to preserve the undo-levels [...] hth, hector. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to copy cell from word that includes line breaks to excel | Excel Discussion (Misc queries) | |||
How do I make an important instruction cell flash in Excel? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel 2003 Word Wrap Problem within cell | Excel Discussion (Misc queries) | |||
Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) |