Add command button to sheet

Good evening,

I was wondering if it is possible to add a command button to a worksheet using vba and to assign what action it is to take (i.e. call a sub routine) after it has been created.

What I am trying to do is have a macro extract the relevant information for a particular user and set it up on a new sheet allowing them to edit it. Once they have edited it, I want the newly inserted command button to call some code to transfer the information back to the main table.

Any ideas?
Thanks in advance
tc

Thanks,

I have the code figured out how to insert the command button but I still don't know how to assign a macro to it using vba. Any ideas?

tc