Add buttons in temp worksheet though VBA (not activeX control)

I would like to create a command button into a temporary worksheet through the use of VBA..

I know how to create the command button, but do anyone have an idea how do I code the function in such a way without having the need to use activeX Control, but only through VBA?

Thank you!