ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Flash on error in result and during entry of data in excel (https://www.excelbanter.com/excel-worksheet-functions/17789-flash-error-result-during-entry-data-excel.html)

NovicExcel

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.




Chip Pearson

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.






NovicExcel



"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?


Harlan Grove

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'.



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com