View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Libby Libby is offline
external usenet poster
 
Posts: 151
Default 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