Help Posting to Active Sheet

[SunRunnerNY]

Ok so this may be an easy one for you pros!
I am try to figure out how to get a userform to post data to an active sheet. The problem is the userform doesn't know what the active sheet is until it is activated by the previous form.
So when the user is presented with the original userform it asls which task they would like to perform. One of these is to add a medication for a client. They click on the button and get an inputbox to scan the client ID # and it opens their worksheet and the userform that has a series of text boxes and a "submit" button. I'm trying to get the values from those textboxes to specific rows/columns on the current active sheet.
I saw this in another thread that I may try:

Please Login or Register  to view this content.

But again, the sheet wouldn't be identified until it is activated by the inputbox.

[LaffyAffy13]

So you're saying that this inputbox identifies which sheet you need? You can just Dim a String and set it equal to whatever the user puts in the inputbox.

[Norie]

The code you posted will put the data on the active sheet because there's no sheet reference.

The only problem is that you are looking at Sheet1 to find the next empty row.

[SunRunnerNY]

So something like this?

Please Login or Register  to view this content.

And I put it at the top of the userform with the values I want on the worksheet?
Isn't there a way to just tell the userform that "hey this is the active sheet that is open right now. Take what I put in the boxes and put it here."?
I'm just confused. Sorry.

[Norie]

If you don't explicitly specify a sheet then something like Cells(erow,4) will refer to a cell on whatever the active sheet is.

Your code doesn't specify a sheet so the data is going to the active sheet.

However because you have specified a sheet, Sheet1, for finding erow it might not be going where you expect it to.

[LaffyAffy13]

I'm still uncertain what you are asking. Norie brings up a good point, but even with that answer I can't identify what you're really asking. As of right now, all of your data is being placed in Sheet2, in columns B-N. They should be placed in the row equivalent to the very last used row in Sheet1. What is your issue?

[SunRunnerNY]

So I can just do away with anything that specifies a a sheet and it should still work?
How would I handle this line in order to get it to post to the next available row?

Please Login or Register  to view this content.

[Norie]

Remove the sheet reference Sheet1.

[SunRunnerNY]

I'm sorry for the confusion but you have to forget the Sheet1 and Sheet2 in the above example. I was just saying that this was the code, disregarding the sheet1 and 2, that I was going to try to get the textbox values from the userform to the active sheet.

[SunRunnerNY]

So again, the staff person opens the application and is presented with a choice of tasks to perform.
One of these is to add a medication to a client's worksheet. They click on the command button and are prompted to scan the client's ID# into an inputbox.
Based on that # it opens a worksheet and a userform. On that form are various textboxes that ask specific questions about the medication.
Thats the point that I have gotten too.
This is the code:

Please Login or Register  to view this content.

[Norie]

I don't like repeating myself but that code is posting to the active sheet.

[LaffyAffy13]

I agree with Norie. I really don't see what your problem is.

[SunRunnerNY]

I'm sorry about that, but I am testing it and it isn't writing to the sheet. Maybe I'm missing it or not seeing it? Man this flips my switch!

[Norie]

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[SunRunnerNY]

OH dang it! It posted it down the page!!!!

[Norie]

Eh, isn't that kind of what I said earlier - it won't got where you expect it because you are using a different sheet to find the next empty row.

[SunRunnerNY]

But I never used the original code posted.
I used this.

Please Login or Register  to view this content.

[LaffyAffy13]

Do you have data in Column A?

[Norie]

When you originally used that code the data would have gone to the wrong row.

Because of that the following code would also goto the wrong row.

For example if that code had put the data on row 334 then any subsequent code would put data under that.

[SunRunnerNY]

Yeah you're right, I see it.
I figured out that I had added a copy of the header down below so staff could use it as a reference to tell which column had what and that the form was posting data below that copy of the header. I removed it and it works good now.
Thanks you guys for being so patient.