VBA editor in Excel 365 MacOS troubles

New Contributor

I am trying to use VBA to create a function in Excel 365 MacOS. There is an annoying feature that makes it very difficult to enter code. As I type, the text shifts and the insertion point moves making each line very difficult to insert.  This is some type of autocorrect/autoformat/autocomplete "FEATURE" that is cursing my ability to correctly enter a line of code.


If for example I want to enter the code  Test=123/456, the resultant code is:

Test = 23456 / 1


While typing the editor moves the cursor and inserts spaces to make the code more legible. I don't mind this so much, but if it does it WHILE typing the code, the resultant input is garbled. I have turned off the autocomplete in the Excel | Preference menu and am not sure where to turn. As this is, I have to go back and correct almost every line I enter, particularly involving numbers and operators. There has to be a switch somewhere to turn this off.




2 Replies



I can't help with your exact question. However, I did want to ask if you're aware of the LAMBDA function, which (in the newer versions of Excel) is a very neat way, not involving VBA, to create user-defined functions. Here's an explanatory reference.


I have made use of it on my Mac, and love it.

Thank you for the kind reply. Yes, I am familiar with the LAMBDA function. I have played with it in 365 for Windows. I am actually using the VBA for a function that is more complicated than my example, which I don't believe will work using the LAMBDA function.