ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Blink specific data in excel (https://www.excelbanter.com/excel-discussion-misc-queries/148993-blink-specific-data-excel.html)

Shafiq

Blink specific data in excel
 
I have a list of products with their Expirty Date. I want when expiry date
near the current system date, a message blink on my desktop with list of
expiry date of products.

Pranav Vaidya

Blink specific data in excel
 
you will have to write a macro that checks the expiry dates with the system
date and flash a message.
You can set this macro to run at a specific interval or on opening the
workbook etc.


Regards,
Pranav Vaidya

"Shafiq" wrote:

I have a list of products with their Expirty Date. I want when expiry date
near the current system date, a message blink on my desktop with list of
expiry date of products.


Dave Peterson

Blink specific data in excel
 
Check out Chip Pearson's site:
http://cpearson.com/excel/BlinkingText.htm

Shafiq wrote:

I have a list of products with their Expirty Date. I want when expiry date
near the current system date, a message blink on my desktop with list of
expiry date of products.


--

Dave Peterson

Pete_UK

Blink specific data in excel
 
Blinking text is not advised, but if you have your heart set on it
then follow this link:

http://www.cpearson.com/excel/BlinkingText.htm

Alternatively, you could apply a conditional format to highlight the
Expiry Date as it nears the system date.

Hope this helps.

Pete

On Jul 5, 6:10 am, Shafiq wrote:
I have a list of products with their Expirty Date. I want when expiry date
near the current system date, a message blink on my desktop with list of
expiry date of products.





All times are GMT +1. The time now is 09:39 AM.

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