VBA Auto-Completing Lines
 

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

VBA Auto-Completing Lines
 

Try to uncheck VBA ToolsOptionsEditor tabAuto Syntax Check
Regards,
Stefi


€žmarkc1728€� ezt Ã*rta:

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

VBA Auto-Completing Lines
 

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" wrote:

Try to uncheck VBA ToolsOptionsEditor tabAuto Syntax Check
Regards,
Stefi


€žmarkc1728€� ezt Ã*rta:

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

VBA Auto-Completing Lines
 

I have no more ideas. What about re-installing Excel?
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

"Stefi" wrote:

Try to uncheck VBA ToolsOptionsEditor tabAuto Syntax Check
Regards,
Stefi


€žmarkc1728€� ezt Ã*rta:

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

VBA Auto-Completing Lines
 

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

"Stefi" wrote:

I have no more ideas. What about re-installing Excel?
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

"Stefi" wrote:

Try to uncheck VBA ToolsOptionsEditor tabAuto Syntax Check
Regards,
Stefi


€žmarkc1728€� ezt Ã*rta:

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

VBA Auto-Completing Lines
 

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

"Stefi" wrote:

I have no more ideas. What about re-installing Excel?
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

"Stefi" wrote:

Try to uncheck VBA ToolsOptionsEditor tabAuto Syntax Check
Regards,
Stefi


€žmarkc1728€� ezt Ã*rta:

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

VBA Auto-Completing Lines
 

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

VBA Auto-Completing Lines
 

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.

"egun" wrote:

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