Automatically assign a macro or code to a commandbutton

[jadadad]

I have an Excel VBA code that automaically creates a commandbutton just fine. But, I'm having difficulity assigning an established macro to it or I'll even take assigning code to the button.

The one liner code is....Sheets(1).Activate

Thanks,

 

[PHV]

Take a look at the OnAction property of your CommandButton object

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244