98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA error
VBA error
Resolved · High Priority · Version 2003
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.
Wed 11 Feb 2009, 14:31Trainer Carlos said...
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
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. |
Excel tip:No ZerosWant all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK. |
