Save Userform content to active sheet.

[pr1nce]

Hi Guys,

I have a feeling this will be incredibly simple and I am just unable to put the right search terms together to find my answer.

I currently have a workbook with 1 sheet and several VBA buttons that open different Userform. Then we enter information and hit save to save in a particular box on that sheet. Very simple stuff.

What I am unable to do so far is copy this sheet many times and have the Userform save to whatever sheet the person using it is in.

Some background to help understand: we are currently a few people using the doc separately, but instead I want to make the doc Shared and with 1 sheet per user. So when person A is on the sheet with their name and uses the userform, it will save to Person A sheet. Currently the code contains

Private Sub ButtonSave_Click()


    Dim emptyRow As Long


    'Make Sheet1 active
    Sheet1.Activate

Im assuming this is what will have to be modified?

Hope I am clear,

Thanks to anyone for their help!

 

[Caribeiro77]

From what i understood i think that you just have to call the sheet that belongs to the person is using the userform, somenthing like this before all other code you may have:

Thisworkbook.Sheets("Sheet_Name_Here").Activate

 

[pr1nce]

The problem with that is I would have to create a userform for each sheet. I want to use the same userform, but save on whatever sheet is active when the button is clicked.

 

[Caribeiro77]

Do you have a button or something else to activate the userform in each sheet?