Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
change cell colors for 2 seconds
Dear users,
I have already a macro running for activecell actvated by ctrl + f. To ensure my colleagues, that the macro did its job, I would like to change the color of the cell for 1 or 2 seconds. Can anybody assists? I recorded a macro and changed the color to yellow and back to 'no fill'. But the macro is too fast - you don't see anything. Is there a possibility to define how many seconds the macro should wait between yellow and no fill? Thanks a lot for your answers. Regards, Rico |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
change cell colors for 2 seconds
Look at ontime http://www.cpearson.com/excel/ontime.htm
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "ricowyder" wrote in message oups.com... Dear users, I have already a macro running for activecell actvated by ctrl + f. To ensure my colleagues, that the macro did its job, I would like to change the color of the cell for 1 or 2 seconds. Can anybody assists? I recorded a macro and changed the color to yellow and back to 'no fill'. But the macro is too fast - you don't see anything. Is there a possibility to define how many seconds the macro should wait between yellow and no fill? Thanks a lot for your answers. Regards, Rico |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
change cell colors for 2 seconds
One way:
Const nWAITSECONDS As Long = 2 'Your code here ActiveCell.Interior.ColorIndex = 6 Application.Wait Now + TimeSerial(0, 0, nWAITSECONDS) ActiveCell.Interior.ColorIndex = xlColorIndexNone In article .com, ricowyder wrote: Dear users, I have already a macro running for activecell actvated by ctrl + f. To ensure my colleagues, that the macro did its job, I would like to change the color of the cell for 1 or 2 seconds. Can anybody assists? I recorded a macro and changed the color to yellow and back to 'no fill'. But the macro is too fast - you don't see anything. Is there a possibility to define how many seconds the macro should wait between yellow and no fill? Thanks a lot for your answers. Regards, Rico |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
change cell colors for 2 seconds
On 5 Jun., 14:11, JE McGimpsey wrote:
One way: Const nWAITSECONDS As Long = 2 'Your code here ActiveCell.Interior.ColorIndex = 6 Application.Wait Now + TimeSerial(0, 0, nWAITSECONDS) ActiveCell.Interior.ColorIndex = xlColorIndexNone In article .com, ricowyder wrote: Dear users, I have already a macro running for activecell actvated by ctrl + f. To ensure my colleagues, that the macro did its job, I would like to change the color of the cell for 1 or 2 seconds. Can anybody assists? I recorded a macro and changed the color to yellow and back to 'no fill'. But the macro is too fast - you don't see anything. Is there a possibility to define how many seconds the macro should wait between yellow and no fill? Thanks a lot for your answers. Regards, Rico- Zitierten Text ausblenden - - Zitierten Text anzeigen - Great. It works. Thanks Bob, thanks JE! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to have row color change based on one cell to 4 colors | Excel Discussion (Misc queries) | |||
Formula to Change Hours:Minutes:Seconds to Seconds only | Excel Discussion (Misc queries) | |||
If a cell is a certain word I would like it to change colors. | Excel Discussion (Misc queries) | |||
CELL & TEXT COLORS DO NOT CHANGE ON MY PC MONITOR | Excel Discussion (Misc queries) | |||
Change value in cell every n seconds | Excel Worksheet Functions |