Help with annoying VBA editor behavior

[jc]

I f I pause more than a second or two while typing in the editor and the last
character I typed was a space the editor automatically backspaces. I then
have to retype the space. Or if a didn't notice it and began typing, I have
to backspace to where it happened and start over.

Is there a way to delay or get rid of this auto backspace behavior?

 

[scattered]

I f I pause more than a second or two while typing in the editor and the last
character I typed was a space the editor automatically backspaces.  I then
have to retype the space.  Or if a didn't notice it and began typing, Ihave
to backspace to where it happened and start over.

Is there a way to delay or get rid of this auto backspace behavior?

A similar problem was mentioned in an Access forum. Someone named
david (not me) posted the following response which the OP said hit the
nail on the head:

*******************************************************************************************

You probably have a form open, with a timer event. Each time the
timer event fires, your code looses focus, and the line is trimmed
back to the last non-whitespace character.

Close the form, or stop the timer.

***********************************************************************************

Maybe something like that is going on here

hth

-scattered

 

[jc]

Thanks

I have a Bloomberg Add-In (To access the Bloomberg Data Base) running all
the time that fires every second or two.

I know this becuase when I record a macro it adds unwanted lines of code
when fires.

I'm sure this must be causeing the problem.

I wish Microsoft or Bloomberg would find a way to avoid this.

 

[scattered]

Thanks

I have a Bloomberg Add-In (To access the Bloomberg Data Base) running all
the time that fires every second or two.

I know this becuase when I record a macro it adds unwanted lines of code
when fires.

I'm sure this must be causeing the problem.

I wish Microsoft or Bloomberg would find a way to avoid this.
--
CroceJC







- Show quoted text -

Maybe you could unistall the add-in while actively editing code. That
should be possible unless there was some reason that your spreadsheet
had to be hooked into real-time data even while in developement/
maintainence mode. It would be nice if you didn't have to choose
between inconvienences. My guess is that the editor behavior is not a
design feature per se but rather an artifact of how buffers are
flushed when focus is lost or something along that line.

-scattered