VBA Auto-Completing Lines

[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

 

[Stefi]

Try to uncheck VBA Tools>Options>Editor tab>Auto Syntax Check
Regards,
Stefi


„markc1728†ezt írta:

 

[markc1728]

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

 

[Stefi]

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


„markc1728†ezt írta:

 

[markc1728]

I do not have access rights to re-install Excel on the pc.

 

[markc1728]

I do not have the necessary permissions to re-install Excel on the pc in
question

 

[egun]

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

 

[Libby]

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.