command button coding

[Praxis]

I would like to add a command button to my form that would create a duplicate form. Basically, copying a sheet automatically by clicking on the button.

 

[stevebausch]

Yep, you can do that. Record a macro of the activity, optimize it (if you desire), and then assign it to a button (if Forms button), or rename it xxxxx"_Click", to take the place of the empty routine that was created for the button when you right-clicked View Code.

 

[royUK]

Hi

Try using the Macro Recorder(Tools>Macro>Record New). Perform your copying and pasting and stop the Recorder. Then assign the Macro to a button

 

[VoG]

This is all the code you need

Sub test()
ActiveSheet.Copy after:=ActiveSheet
End Sub


Place button on the worksheet and assign it to the macro.

 

[Praxis]

Thanks guys... It took me a little while, but I finally got it to work.