Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA error
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA error
Resolved · High Priority · Version 2003
Reply Sun 25 Jan 2009, 15:14Delegate John said...
John has attended:
Excel VBA Intro Intermediate course
VBA error
I received the error"Compile error:Expected:Identifier" when try to create a procedure. The error appeared when hit enter after typing Sub.
For upcoming training course dates see: Pricing & availability
Compile error:Expected:Identifier
Hi John
When creating a procedure you have to give the procedure a name.
By pressing Enter immediately after writing Sub causes the "Compile error:Expected:Identifier" error because you haven't named the Procedure.
If you enter
Sub MacroName
and then press enter.
You will create a procedure with no problems unless you already have a procedure in the module with the same name
Carlos
Reply Wed 11 Feb 2009, 20:35Delegate John said...
RE: Compile error:Expected:Identifier
Thanks Carlos. I was doing VBA for the first time after few attempts I have already figured it. Many thanks for answering this question
|