VBA & Macro Problems

Stop the Excel VBA Editor from Changing Code While Typing on Mac

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 868 views

Question details

The user wants to stop the Excel VBA editor from changing code or moving the insertion point while they type.

Stop the Excel VBA Editor from Changing Code While Typing on Mac
Product
Microsoft Excel 365 for macOS
Device & OS
macOS
Scenario
Entering VBA code character by character in the Visual Basic Editor.
Observed behavior
Numbers, operators, spaces, or the insertion point appear to move or rearrange while code is being entered.
Before you start

Open the affected workbook in Excel and note which characters or cursor movements trigger the issue. Check whether the same behavior occurs in a new, blank VBA module.

Solution 1Recommended

Check VBA editor settings and update Excel for Mac

Use these checks to identify whether editor assistance or an outdated Office installation is contributing to the typing issue.

1
Open the VBA editor

In Excel, open the Developer tab and select Visual Basic. If the Developer tab is hidden, enable it under Excel > Preferences > Ribbon & Toolbar.

2
Review editor options

In the Visual Basic Editor, look for an Options or Preferences menu. If available, temporarily turn off Auto List Members, Auto Quick Info, or automatic syntax checking, then try typing the same line again. Available settings can vary by version.

3
Check for Office updates

In Excel, select Help > Check for Updates and install any available updates through Microsoft AutoUpdate. Restart Excel and test the VBA editor again.

4
Test the keyboard input source

Use the macOS input menu to switch to an English keyboard input source, then type the affected characters again in the VBA editor. This can help isolate an input-source issue.

Check VBA editor settings and update Excel for Mac
If the issue continues: Try pasting complete lines from a plain-text editor into the VBA module instead of typing them character by character. Review the pasted code before running it.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easier to move everyday workbook tasks to WPS. It does not fix the Microsoft Excel VBA editor.

Edit and calculate spreadsheet data in WPS Spreadsheets without using the Excel VBA editorOpen and save common Microsoft Excel formats, including XLSX and XLSUse a familiar interface for a smoother transition from Microsoft OfficeGet a free, lightweight suite for everyday office work
microsoft office alternative - wps office

Frequently Asked Questions

Why does the VBA editor change my code while I type?

Editor assistance, an input-source interaction, or an Excel editor bug may contribute, but the cause depends on the behavior. Test a blank module, review available editor options, and update Excel through Help > Check for Updates.

Can I stop code completion in the VBA editor on Mac?

Look for Options or Preferences in the Visual Basic Editor and, if the settings are available, turn off Auto List Members and Auto Quick Info. The options available may vary by Excel version.

What can I do if the cursor keeps moving in the VBA editor?

Switch to an English keyboard input source using the macOS input menu and test again. You can also write a complete line in a plain-text editor and paste it into the VBA module.

Can LAMBDA replace my VBA macro?

LAMBDA can replace some custom functions that calculate a value using worksheet formulas. It cannot replace macros that automate Excel actions. Create a reusable LAMBDA through Formulas > Name Manager in a supported Excel version.