usernamepass
11-27-2011, 10:29 AM
I am having a strange problem that I have never had before with VBA.
Whenever I try to type something in the main code window for anything (a Worksheet/Userform/Modules), as I type VBA keeps highlighting my code in red and if I stop typing VBA begins to delete what I just typed (usually one or two characters).
This is only happening for the workbook that I am currently working on, all the other ones are fine.
I just wanted to know if there was some setting that I accidentally hit that is causing VBA to do this.
I am using a lot of ActiveX controls which may be the issue.
Edit: I tried deleting everything of of my first worksheet code window and typed in a random three letters and hit space. It keeps popping up a window that says "invalid outside procedure." Windows keep popping up and I eventually just have to force quite (after 15-30 are on the screen and more are coming).
I also tried on another laptop and the same thing happened (with this workbook).
Whenever I try to type something in the main code window for anything (a Worksheet/Userform/Modules), as I type VBA keeps highlighting my code in red and if I stop typing VBA begins to delete what I just typed (usually one or two characters).
This is only happening for the workbook that I am currently working on, all the other ones are fine.
I just wanted to know if there was some setting that I accidentally hit that is causing VBA to do this.
I am using a lot of ActiveX controls which may be the issue.
Edit: I tried deleting everything of of my first worksheet code window and typed in a random three letters and hit space. It keeps popping up a window that says "invalid outside procedure." Windows keep popping up and I eventually just have to force quite (after 15-30 are on the screen and more are coming).
I also tried on another laptop and the same thing happened (with this workbook).