VBA Module window problem

[JapanDave]

Hey all,

I am having problems entering code into the module window. Eg I start to write a new sub, obviously the first thing you write is the word Sub, but this is where it gets strange. When I press the space bar, the curser jumps back to where it was and the word "Sub" then it shows up in red text as if there is an error. But of coarse that can't be the case b/c I have not even written any code yet. No matter how many times I try to put in a space it always jumps back. So you can see that I cannot write any code right now.

Anyone know what this is and how to fix it?

[MarvinP]

Hi JapanDave,

Do you have a Sub above where you are typeing Sub? I'm thinking you are trying to put a Sub inside a Sub and that isn't allowed. Also, perhaps you don't have an End Sub to stop the above Sub?

Also - look at Tools -> Options to see if things make sense there.

It almost seems like your "Space" has been replaced by an ENTER character. Do you have some keyboard macro running that converts a space to a return?

Is there a chance the Ctrl key is stuckk on your keyboard making a space different? See
http://www.cpearson.com/excel/vbashortcutkeys.htm

[JapanDave]

Hi JapanDave,

Do you have a Sub above where you are typeing Sub? I'm thinking you are trying to put a Sub inside a Sub and that isn't allowed. Also, perhaps you don't have an End Sub to stop the above Sub?

Hey Marvin,

It is a new workbook and a new module.

First time I saw this was when I was editing code from someone else. But I don't have that workbook any more as it is deleted from my PC.

[MarvinP]

I've added 2 edits to my original post. Ctrl key stuck? Also re-read my first post.

In Word you can create substitute words that tricks people. I believe it is using AutoCorrect feature. I don't think Excel has this but I wonder if your keyborad is programmable and is doing something like it?

Is the AutoCorrect part of the spell checker?

[JapanDave]

Marvin there is definitively something funky going on. And it could possibly be a macro running and doing something. Why I say this is b/c it started when I was editing a macro that someone else had made.

But I may have fixed things, I went into the downloads folder and deleted all the excel files there(That workbook I was talking about was still there) and when I started to write a sub again , things were back to normal. Maybe I downloaded a bad macro and it was doing funny things? Anyway it seems to be fixed now.

Thanks for the help.