Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
I have the following 2 message boxes
I've tried but I'm unable to amend the code in each line beyond the dot to create a comma separator for the thousands.
Help appreciated!
Thank you.
I have the following 2 message boxes
VBA Code:
If 1000 - A <= 100 Then MsgBox 1000 - A & " miles to go until you hit " & Range("CG375").Value + 1000 - A
If A > 0 And A <= 10 Then MsgBox "Congratulations! You have now run over " & Range("CG375").Value - A & " miles"
Help appreciated!
Thank you.