Copy Sheet with userform buttons to another sheet in same workbook

[sidt87]

Hi,

I've created a worksheet that has userform buttons on sheet1 and I would like to copy it to sheet2. How can I copy it so that the buttons would work for sheet2? The reason is I need to separate shift entries.

thanks!

 

[Logit]

Click the upper left corner of the worksheet you want to copy. The small square with the triangle pointing right & down.
This selects the entire sheet.

Right click anywhere on the worksheet and select copy.

Move to the sheet you want to paste to.

Right click in cell A1 / select PASTE.


Now ... if both sheets are exactly alike in the data layout and use of cells, any macro used by the button on the first sheet, should work on the second sheet,
so long as the macro used relative references. In other words, if the macro has any code that says "Sheets("Sheet1") and you are trying to use the same
button/macro on Sheet 2 ... it won't work.

You will need to create new macros to work with the second sheet UNLESS, the code is written otherwise.