Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA error

VBA error

ResolvedVersion 2003

Sun 25 Jan 2009, 15:14 Delegate 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:31 Trainer 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

Wed 11 Feb 2009, 20:35 Delegate 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

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips

VBA error

VBA error

Compile error:Expected:Identifier

RE: Compile error:Expected:Identifier

Excel articles

Excel tip:

Use the SUBTOTAL function in Excel