Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto filter on blank lines | Excel Discussion (Misc queries) | |||
Auto insert of blank lines | Excel Discussion (Misc queries) | |||
Auto Completing Fields but not changing later... | Excel Discussion (Misc queries) | |||
Auto Complete not completing | Excel Discussion (Misc queries) | |||
Entering Dates and auto-completing | Excel Programming |