UniqueData
asked on
Disable error message in VBA
I can never remember how to turn off the error messages in VBA while typing. I know there is a setting that will let the text become red but not pop up the error message. Can somebody help me find it?
Thanks in advance.
Thanks in advance.
Tools-Options Editor Tab, uncheck Auto Syntx Check
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks again for your answer. You have once again come to my aid.
I like to copy and paste alot and sometimes I leave a line of code to grab another piece of code (variable names, etc). I never like getting that error message because I know I am coming back to the line to finish it.
I find it enough to keep the text colored red, but I can see your point too. Wouldn't a compile point out any of the same errors that "Auto Syntax Check" will find?
I like to copy and paste alot and sometimes I leave a line of code to grab another piece of code (variable names, etc). I never like getting that error message because I know I am coming back to the line to finish it.
I find it enough to keep the text colored red, but I can see your point too. Wouldn't a compile point out any of the same errors that "Auto Syntax Check" will find?
For some of us, short term memory is a problem....red lines help in that case(:-)
Well...when I say 'some of us'.......
Well...when I say 'some of us'.......
The points should go to Mike really - he was first
Well, as I said - I HATE the compile error messge box from auto syntax check. The highlighted text is indeed ample and yes - a compile would highlight the same issues.
I would literally be a gibbering wreck by this stage of my life if every time I'd left a line of partial code I got that ******* message.
Fortunately my short term memory isn't as bad as Pete's. :-)
Oh and the points should go to Mike really - he was first.
Have I mentioned that I hate the auto syntax check?
Well, as I said - I HATE the compile error messge box from auto syntax check. The highlighted text is indeed ample and yes - a compile would highlight the same issues.
I would literally be a gibbering wreck by this stage of my life if every time I'd left a line of partial code I got that ******* message.
Fortunately my short term memory isn't as bad as Pete's. :-)
Oh and the points should go to Mike really - he was first.
Have I mentioned that I hate the auto syntax check?
Leigh,
Thanks, but I did have the spelling mistake: Syntx ;¬}
Cheers,
Mike
Thanks, but I did have the spelling mistake: Syntx ;¬}
Cheers,
Mike
Oh man... that stynx. :-)
Have I mentioned that I hate the auto syntax check?
Have I mentioned that I hate the auto syntax check?
ASKER
Sorry about that Mike,
For some reason I didn't see your answer....odd. Is there anyway I can re-apply them?
For some reason I didn't see your answer....odd. Is there anyway I can re-apply them?
No worries, life goes on!
Did he mention that he hates the auto syntax check?
Did he mention that he hates the auto syntax check?