Having upgraded from MacBook Air (Catalina OS) to Mac Book Pro M1 (Big Sur OS) the same goal seek macro results in a crash of Excel on the MacBook. Having spent all day investigating with apple and your support team it seems that there is a problem with Ver 16.45 running on the MacBook Pro (Big Sur). The same machine will run the macro on ver 15.41 but not on Ver 16.45 . However ver 16.45 running on the MacBook Air works. Please resolve as this is likely to be happening to others also. Your support team has the error report to raise internally.

Many issues with VBE including...

When adding part of a line of code in the editor such as select case<space> and then I pause to think auto syntax checking seems to run (even if its turned off in preferences and irrespective of whether I'm in design mode)
The result is that the line turns red and the space is removed. The consequence is that as I type the next part of the statement the space is removed and I end up with a syntax error.
This issue is irrespective of where I save the document (OneDrive, iCloud or local to the mac) and whether autosave is on or off. Even if I clear all the check boxes in Preferences Editor the problem persists.
Additionally but not obviously related the editor also seems to drop a number of the characters I type. Neither of these issues ever happened when I ran under Windows.
I am running latest 356, latest Big Sur on M1 MBP.

Dear Excel Team,
I have a macro, and I want Excel to display a modeless (non-modal) message to the user while the macro is running. That way, the user will know that the macro is still running, and has not crashed. I would like this message to go away when the macro is done. Then I could fire a new message, indicating "Done!"
I do NOT want to use the status bar for this, since the status bar is not conspicuous enough.
The MsgBox function does not work, because it prevents the rest of the macro from running.
I can't create a UserForm to do this, because I'm on a Mac, and as I understand it, VBA for Mac cannot create UserForms.
I would be so grateful if you would let me know if I am correct that there is currently no way to develop a modeless information box on Excel for Mac, and, here are my suggestions:
1) I think everyone who develops macros worries that users will be confused when the program stops responding. Therefore, I think it really important that Excel provide a pre-fab ("canned") method of showing a conspicuous message during macro execution.
2) Even better would be for you to provide a pre-fab ("canned") progress monitor for macro developers to include.
3) I am not an advanced programmer, and I have no need of UserForms. I was only interested in that because it seems that, on Windows machines, UserForms are the only way to create modeless message boxes. Unfortunately it seems that there is no way to create modeless message box on the Mac platform. I think it is really strange and, well, kind of bad, that VBA for Windows allows creation of UserForms while VBA for Mac does not. Seems like the sort of thing that could get people in trouble vis a vis anti-trust stuff, given MS's long rivalry with Apple.
Anyway, I would be so grateful for your input on the above.
Thank you!
Danny