Add Code To Button Click Event Using VBA

[chergh]

hey folks,

I'm creating a button on a worksheet using VBA and then want to add code to the buttons click event. So far i have this:

Please Login or Register  to view this content.

On the last line I receive a "Run Time error '9': Subscript outof range". Any able to shed some light on this?

[michelxld]

Hi,

You may try

Please Login or Register  to view this content.

Regards
michel