How to disable the "compile error expected end of statement" from showing in vba
excel, vba
Solution
Annoying isn't it? Click `Tools` -> `Options` -> `Editor` Tab and uncheck Auto syntax check
Problem
Frequently when entering code I will type half of a line, for example the opening part of an if statement, but rather than type the second half I will want to copy and paste, both for convenience and to minimize the chance of a typing error. However if I move the focus away from a half completed statement I get the very annoying "compile error, expected end of statement" pop up which I must acknowledge. This is becoming very tedious when it comes up so often. Is there any way to tell excel not to show this error message?