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.
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.