PDA

View Full Version : VBA Editor Nuisance Behavior



Shred Dude
05-30-2011, 10:35 AM
I'm experiencing behavior within my VBA Editor that is very annoying. I'm wondering if anyone here has had similar experiences and perhaps found a solution.

It seems that quite often when typing code, the cursor position will revert backwards after typing a space. This results in words not being separated and the resulting line of code being highlighted in Red as it is not correct.

I then have to manually go through an insert spaces where needed, and at times this takes several attempts since while doing this the same behavior of having the cursor revert back to the left will present itself.

Very annoying and unproductive. :banghead:

This behavior is not always present, but often it is. I can't seem to isolate a particular circumstance when this occurs. It happens in Excel VBA as well as other Office Apps' VBA.

Environment: Windows7, Office 2007

Any ideas?

Thanks,

Shred

JP2112
06-17-2011, 01:11 PM
I thought I was the only one with this problem. What addins are you using?

Shred Dude
06-17-2011, 08:21 PM
Good question. I'm pretty sure that this behavior began after installing MZ-Tools 3.0 for VBA and VBA Code Cleaner 5.0. I installed MZ Tools first, and then Code Cleaner a day or two later.

I've also experienced it I've had a Visual Studio (2010 Professional Edition) project open.

I can't seem to isolate a circumstance however that causes it repeatedly. Maybe I should try uninstalling the addins and see if it still happens. Do you run those add-ins?

I run Office Professional 2007 on Windows 7.

JP2112
06-18-2011, 12:07 PM
I'm using both of those addins at home, but only Code Cleaner at work. So the problem might be with Code Cleaner.

The addin looks like it hasn't been worked on in some time, so the only solution I can think of at the moment is simply to keep it uninstalled, then install and use it when needed and remove it right after.

Bob Phillips
06-20-2011, 09:25 AM
I have MZ-Tools and Code Cleaner, and I have no such problems (problems with my fat fingers, but that is another matter)

JP2112
06-20-2011, 06:42 PM
Aren't you using 2003? Do you have the '07 compatibility pack installed?