Hello Pros,
This might be challenging, but I don't know if it's fixable.
I found a video on how to calculate from text or in a table.
It works wonderfully, not the formula function but more like from this link, to add a command called:
Calculate
How to Perform Simple Calculations in Microsoft Word
The thing about it, is the it doesn't last long to show the results in the status bar, but it's accurate.
I was so proud of myself to have found a way to include a msgbox, like that it stays.
If I use the command/icon methode such as in the link above, I get the results accurately and the numbers are fully formatted.
*******Problem.
When I use the MsgBox which I've also created myself a personalized Word Tab and created my own Icon to calculate with the MsgBox and add such as these numbers as an example which I've tried In and Out of a table:
5,000,000
10,000,000
15,000,000
Select these 3 numbers, I click on the my Word VBA Icon = I get 3E+07 in the MsgBox.
Code:
'use this line below, only if in tables.
Selection.SelectCell
MsgBox Selection.Calculate
Question:
How to get a MsgBox + Fully Formatted either with or without symbols $% + Without an 3E+07 message?
Unless it's not doable?
Any insights in the problem I get, I would be soooooooooooooooo grateful.
If it's not doable, please let me know so I will stop searching.