Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
NovicExcel
 
Posts: n/a
Default Flash on error in result and during entry of data in excel

Here is a scenerio

Food Yes/No
Apple No Yes Revise Your Diet
Banana Yes No
Pears Yes


Revise Your Diet




"Revise Your Diet " is an Error Message &
My question is how to Make this flash.. blink etc ??? bottomline is how or
is it possible to flash back such error with some effect that alerts
instantly . Like in online EXAM or poll or survey etc. How to do so in EXCEL.



  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

Excel does not support flashing text.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"NovicExcel" wrote in
message
...
Here is a scenerio

Food Yes/No
Apple No Yes Revise Your Diet
Banana Yes No
Pears Yes


Revise Your Diet




"Revise Your Diet " is an Error Message &
My question is how to Make this flash.. blink etc ???
bottomline is how or
is it possible to flash back such error with some effect that
alerts
instantly . Like in online EXAM or poll or survey etc. How to
do so in EXCEL.





  #3   Report Post  
NovicExcel
 
Posts: n/a
Default



"NovicExcel" wrote:

Here is a scenerio

Food Yes/No
Apple No Yes Revise Your Diet
Banana Yes No
Pears Yes


Revise Your Diet




"Revise Your Diet " is an Error Message &
My question is how to Make this flash.. blink etc ??? bottomline is how or
is it possible to flash back such error with some effect that alerts
instantly . Like in online EXAM or poll or survey etc. How to do so in EXCEL.

I don't mean animatioin, in the scenerio above gave result "Revise Your Diet" (EXAMPLE)which is an error I want to make it auto with extra alert function so any suggession?

  #4   Report Post  
Harlan Grove
 
Posts: n/a
Default

NovicExcel wrote...
....
My question is how to Make this flash.. blink etc ??? bottomline is

how or
is it possible to flash back such error with some effect that alerts
instantly . Like in online EXAM or poll or survey etc. How to do so

in EXCEL.

I don't mean animatioin, in the scenerio above gave result "Revise

Your Diet"
(EXAMPLE)which is an error I want to make it auto with extra alert

function
so any suggession?


Excel provides *NO* built-in means of *CHANGING* any format
characteristic
automatically at any frequency. That means 'flashing' would be changing
cell background (interior) and text colors between two (or more?)
different
states at a frequency like once or twice per second. You could only do
that
with VBA code, and the result would noticeably degrade Excel's
performance.

If your absolutely certain you want to do this, then search the Google
Groups
archive for past threads containing the word 'flashing'.

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



All times are GMT +1. The time now is 05:54 AM.

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

About Us

"It's about Microsoft Excel"