Excel for mac vba programming7/12/2023 But I have had this issue for 2 years on 2 or 3 different macOS versions, and 5 or 6 different computers, and even more Excel versions (insider or regular), so I don't think this is relevant. PS: I'm running MacOS Catalina, Excel Version 16.40 on an iMac. Is the editor a native app or running in some sort of virtualized sandbox? Hovering the mouse over the icons in the ribbon is the same, hover the mouse over an icon, the helper bubble will appear a second later, although Mouse selection of the text is just as slow, and because of that, sometimes you end up selecting the wrong thing. Typing this sentence would take me a minute, with each character slowly appearing one by one, a couple of seconds The issue is this, open excel, blank sheet, open the VBA editor and then you're in a world of pain with every action being delayed by a second. Questions about using VBA on mac, and no one else seems to have the same issue, which surprises me. But now I do, and it is still just as slow as 2 years ago, and I see people asking At first, I thought it will get better, and didn't really care that much because i didn't need to use it as much. This means you now have the debugging tools used in Excel for Windows. Please note that the most recent version of Excel for Mac has finally upgraded its Excel VBA Editor. I had to change the file path (obviously) but the other change needed is the format in which apple recognises path. A few things to know about Excel VBA for Mac. I've been struggling with this issue for the past 2 years. I developed a macro/VBA script in Excel (running on wondows) and need to implement it on my customers machine who has a mac book.
0 Comments
Leave a Reply. |