VBA Auto-Completing Lines

  • Thread starter Thread starter markc1728
  • Start date Start date
M

markc1728

When I try to enter a line of code in vba (Excel 2003) the editor highlights
errors before I have finished typing the code. More annoyingly it adds the
second quotation marks (") as I am typing, this is making it almost
impossible to write formulas into cells as I lose track of where I am with
them.

I have tried turning all of the references off (except the 11.0 object
libraries) and there are no add-ins turned on
 
Try to uncheck VBA Tools>Options>Editor tab>Auto Syntax Check
Regards,
Stefi


„markc1728†ezt írta:
 
Hi,

I have already tried this and it still does it. I have also tried restarting
all office applications. Please note this is only happening in excel, not
access or word (as far as I can tell)

Thanks
 
I have no more ideas. What about re-installing Excel?
Stefi


„markc1728†ezt írta:
 
I have had this happen to me also. All of the sudden the VBA editor will
start trying to complete my lines, add quotation marks, syntax check a line
before it's even complete, etc.

I usually fix the problem by getting out of Excel and getting back in. I
wish I knew what caused it in the first place, but I don't.

I guess I just want to let you know I feel your pain!

Eric
 
The only time this has happened to me is if code is being run elsewhere. Try
putting the workbook in design mode or open with macros disabled.
 
Back
Top