Aug 02 2019 07:33 PM - edited Aug 30 2019 07:40 PM
Please provide some useful info about the problem!
The visible part of the code in the first screenshot doesn't seem to have an error!
However, the Overflow error is one of the most popular runtime errors in VBA, please check out this documentation article to learn more about it and how to fix it.
Aug 30 2019 02:32 PM
I have exactly the same problem as isabelaj: When I declare a variable as double I cannot assign any value to that variable. It results always the overflow error message.
Aug 30 2019 07:54 PM
Aug 31 2019 01:34 AM
@Haytham AmairahThank you for your answer. But my problem is not the same because I receive the error message of overflow even with that little program:
Dim a As Double
a = 20.3
Error message in the third line.
As I read in an other chat, this program runs well on a Windows Computer but not on the Mac.
Aug 31 2019 01:58 AM
Aug 31 2019 03:01 AM
@Haytham AmairahThank you again for your test. I am shure now that there is a problem with Excel on Mac and even the newest version on an brandnew MacBook 12". I had a chat with a Microsoft Expert yesterday and he promised me to contact the developpers so that there will be the solution in the next update. I hope ...
Sep 04 2019 05:04 PM - edited Sep 04 2019 05:06 PM
@PeterGallinI have found a temporary solution of the mentioned problem:
Dim a As Variant
a = 20.3
Apr 14 2021 08:40 AM
Dec 20 2022 01:36 PM
@PeterGallinyou made my day.
This is one of the "Traffic-light" errors ("On-Off-On-Off") that escort us thru Office Versions on MacOS since 2004. If you think some version is clean, the next update brings the bug back.
Dec 20 2022 01:42 PM - edited Dec 20 2022 01:42 PM
For chinese characters to be displayed correctly in formula results, it took MS from Office4Mac2004 (2005) to Office 365(around 2020). They are only 200 developers there, so be patient. But they finally will do it. :-DDD