Userform appears when worksheet is copied

[shawnvon]

Hello,
I have worksheets with different employees on separate tabs that are paid based on a compensation system inherent to their position and certain inputs. What I want to do is have a userform box appear whenever a worksheet is copied and allow the user to input the information unique to that employee (inputs are unique things like ID number, email, compensation rate, etc.). I know how to create a userform but how do I get it to automatically appear whenever a worksheet is copied?

Not sure if there is already a post on this but any help would be appreciated. I couldn't find anything online or in this forum but maybe I'm not searching the right terms.

Thanks in advance.

Shawn V.

[Norie]

How are you copying the worksheet?

[shawnvon]

by right clicking and create a copy. Is there an easier/better way?

[Norie]

I thought you might have been using a button on the sheet you were copying.

If you were you could have added code to show the userform, take user input etc.

[shawnvon]

I like that idea. How would I go about it?