![]() |
Change linkedcell color for a minute only when value changes
Hi,
I have a worksheet that obtain some data from web via a query, refreshing every minute. Using VBA I copy links of some of the obtained data in another worksheet of the same workbook (this second worksheet is a sort of "filter" of the main worksheet). Since I copy only links to the cell of the first worksheet, every time the main worksheet updates from web, the values of the second worksheet updates too, and this works very well. But my question is: How can I do if I want that cells of the second sheet whose value had changed from a refresh to the other (because this value of course is changed originally in main sheet) change their color for a certain period (e.g. 30 seconds) and then restore to their original color in an automated way ? I don't understand if this is possible via VBA. Thanks to anyone that could help me. TJ |
All times are GMT +1. The time now is 11:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com