• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1797
  • Last Modified:

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.
0
UniqueData
Asked:
UniqueData
  • 3
  • 3
  • 2
  • +1
1 Solution
 
MikeTooleCommented:
Tools-Options Editor Tab,  uncheck Auto Syntx Check
0
 
Leigh PurvisDatabase DeveloperCommented:
From a VBE window  Tools>Options>Auto Syntax Check.

It is 100% invaluable.  Completely necessary and I would not be sane without it.
0
 
UniqueDataAuthor Commented:
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?
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
peter57rCommented:
For some of us, short term memory is a problem....red lines help in that case(:-)

Well...when I say 'some of us'.......
0
 
Leigh PurvisDatabase DeveloperCommented:
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?
0
 
MikeTooleCommented:
Leigh,
Thanks, but I did have the spelling mistake: Syntx   ;¬}
Cheers,
Mike
0
 
Leigh PurvisDatabase DeveloperCommented:
Oh man... that stynx.  :-)

Have I mentioned that I hate the auto syntax check?
0
 
UniqueDataAuthor Commented:
Sorry about that Mike,

For some reason I didn't see your answer....odd.  Is there anyway I can re-apply them?
0
 
MikeTooleCommented:
No worries, life goes on!
Did he mention that he hates the auto syntax check?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now