Compile error: expected end of statement occurs when 'Handles' keyword is used

[RowanB]

I'm sorry for asking what is probably a noob question, but I've just started learning VBA and don't understand why this happens. I'm trying to make a command button in a user form that initiates a sub routine when it is pressed, but when I start trying to code this subroutine using:

Please Login or Register  to view this content.

I get the error message; 'Compile error: expected end of statement occurs' with the word 'Handles' highlighted.

Any help is much appreciated,

Rowan

[shg]

The signature for a VBA command button click event is just

Please Login or Register  to view this content.

[romperstomper]

The code you have is VB.Net and not VBA.

[RowanB]

Thanks a lot. I guess I've bought a big fat book that doesn't have much use to me. I bought 'Mastering Visual Basic 2010'. At least I can focus on studying something else while I wait for a new book to arrive I guess. Are there are any books you can recommend to me please?

[romperstomper]

Any of the VBA books by John Walkenbach or Bill Jelen are good; the VBA developers handbook is the best pure VBA book I've ever seen, but you may want more excel related ones

[RowanB]

Thanks a lot.

[romperstomper]

No problem. If you were further South, I might offer you a swap.

Please don't forget to mark the thread solved.

[RowanB]

Ah, pity we can't trade. I bought Excel 2007 Power Programming with VBA: Mr. Spreadsheet's Bookshelf Series, Book 2. Hope it's useful. Thanks again.