Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
Sheet 'Daily Tracking' Cell CG375 contains a value, currently 27851 and is increasing.
What I'd be really grateful for is a message box that is triggered when I open the workbook if/whenever the value in Sheet 'Daily Tracking' Cell CG375 is within 100 of the next 1000 i.e. it will next trigger between 27900 and 28000. It will then trigger between 28900 and 29000 and so on and in each case it calculates the difference between the two values.
e.g. for 27900 the message would be "100 miles to go until you hit 28,000 miles".
Also, if possible, when the value is equal to or greater than the 1000 by up to 10 e.g. 28000 - 28010 a different message is triggered e.g. "Congratulations, you have now run over 28,000 miles"
I'd also appreciate it if the value could be rounded up to the nearest whole number.
Many thanks!
Sheet 'Daily Tracking' Cell CG375 contains a value, currently 27851 and is increasing.
What I'd be really grateful for is a message box that is triggered when I open the workbook if/whenever the value in Sheet 'Daily Tracking' Cell CG375 is within 100 of the next 1000 i.e. it will next trigger between 27900 and 28000. It will then trigger between 28900 and 29000 and so on and in each case it calculates the difference between the two values.
e.g. for 27900 the message would be "100 miles to go until you hit 28,000 miles".
Also, if possible, when the value is equal to or greater than the 1000 by up to 10 e.g. 28000 - 28010 a different message is triggered e.g. "Congratulations, you have now run over 28,000 miles"
I'd also appreciate it if the value could be rounded up to the nearest whole number.
Many thanks!
Last edited: