Solved

Disable error message in VBA

Posted on 2006-11-14
9
1,763 Views
Last Modified: 2008-01-16
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
Comment
Question by:UniqueData
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 27

Expert Comment

by:MikeToole
Comment Utility
Tools-Options Editor Tab,  uncheck Auto Syntx Check
0
 
LVL 44

Accepted Solution

by:
Leigh Purvis earned 50 total points
Comment Utility
From a VBE window  Tools>Options>Auto Syntax Check.

It is 100% invaluable.  Completely necessary and I would not be sane without it.
0
 
LVL 7

Author Comment

by:UniqueData
Comment Utility
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
 
LVL 77

Expert Comment

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

Well...when I say 'some of us'.......
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 44

Expert Comment

by:Leigh Purvis
Comment Utility
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
 
LVL 27

Expert Comment

by:MikeToole
Comment Utility
Leigh,
Thanks, but I did have the spelling mistake: Syntx   ;¬}
Cheers,
Mike
0
 
LVL 44

Expert Comment

by:Leigh Purvis
Comment Utility
Oh man... that stynx.  :-)

Have I mentioned that I hate the auto syntax check?
0
 
LVL 7

Author Comment

by:UniqueData
Comment Utility
Sorry about that Mike,

For some reason I didn't see your answer....odd.  Is there anyway I can re-apply them?
0
 
LVL 27

Expert Comment

by:MikeToole
Comment Utility
No worries, life goes on!
Did he mention that he hates the auto syntax check?
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now