Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 21
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,593
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4,624
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 21
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to have row color change based on one cell to 4 colors Mel Excel Discussion (Misc queries) 1 September 20th 06 10:47 PM
Formula to Change Hours:Minutes:Seconds to Seconds only Cheri Excel Discussion (Misc queries) 4 August 30th 06 12:44 AM
If a cell is a certain word I would like it to change colors. Mike Excel Discussion (Misc queries) 2 January 25th 06 08:57 PM
CELL & TEXT COLORS DO NOT CHANGE ON MY PC MONITOR COLOR PROBLEMS Excel Discussion (Misc queries) 2 January 19th 06 06:23 PM
Change value in cell every n seconds Stan Altshuller Excel Worksheet Functions 1 December 23rd 04 08:51 PM


All times are GMT +1. The time now is 06:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"