Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 09-12-2022, 08:00 PM
Cendrinne's Avatar
Cendrinne Cendrinne is offline Help Please, MsgBox with Calculate Windows 10 Help Please, MsgBox with Calculate Office 2019
Competent Performer
Help Please, MsgBox with Calculate
 
Join Date: Aug 2019
Location: Montreal Quebec Canada
Posts: 200
Cendrinne is on a distinguished road
Default

Quote:
Originally Posted by Guessed View Post
It appears that Word and Excel start using the "10 to the power of" formatting if the numbers have 8 digits or more. When the numbers are smaller than that you don't need to worry about it too much.

You can make the code more complex to let Word choose its own format when the numbers are less than 10,000,000 by using an If/Else in your code.

I don't know why the StatusBar display method treats the result differently.

Maybe you would find this works better for your scale of numbers
MsgBox CDbl(Selection.Calculate)
Interesting. OK, I'll stop for tonight, or else I will be too tired tomorrow.
Thank you thank you thank for the lesson.

Interesting topic

If I do find the answer one day, I'll let you know

Night my forum smart friend
Reply With Quote
 

Tags
helpme; calculate



Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there any way to get MsgBox columns to line up? Jennifer Murphy Word VBA 3 03-01-2020 12:13 AM
Help Please, MsgBox with Calculate Word VBA - Ignore MsgBox crazzyapple Word VBA 2 11-08-2018 12:06 AM
Help Please, MsgBox with Calculate Problem with Msgbox in VBA Puzzled Programmer Excel Programming 6 09-06-2018 04:34 PM
msgbox when deleting cells Mikedk64 Excel Programming 11 07-13-2017 07:14 AM
Help Please, MsgBox with Calculate Make MsgBox appear... Jamtart PowerPoint 3 09-01-2012 08:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft