PDA

View Full Version : [SOLVED:] VBA editor syntax problem



austenr
12-30-2004, 09:37 AM
I am having trouble getting the first line to stay a small "C" instead of a capital. Any suggestions? EXCEL 97.



CmdSelect.Enabled = True ' May be temporary
cmdUndo.Enabled = False

mvidas
12-30-2004, 09:43 AM
You want it to look like:

cmdSelect.Enabled = True ' May be temporary
?

Just put the line:

Dim cmdSelect

Anywhere in any module. After you press enter, delete the line. Voila!
Matt

Zack Barresse
12-30-2004, 10:18 AM
It's probably like that because you most likely have it defined somewhere else in the project. ?? :dunno Is this a possibility?

Ken Puls
12-30-2004, 10:41 AM
Hi Austen,

Is CmdSelect the name of a button or some other control you are using? If so, try going back to the control and checking the name... you may have capitalized it there.

austenr
12-30-2004, 10:43 AM
Thanks guys, sometimes it is the obvious that is the most frustrating!! Mark solved.