Populate row on sheet with textbox value in columnumber equal to textboxnumber

Hello,

I could really really do with some help with a Userform.

The UF consist of over 90 textboxes divided over a number of frames, but not sequential (unfortunately)

So
- Frame1 might have textbox1, textbox2 and textbox7
- Frame2 might have textbox3, textbox9 and textbox5 ... and so on.

Each frame has a submit button.

Upon clicking the submit button I would like to have the values of the textboxes from that particular frame to be placed:
- on sheetx
- in row2
- in the columnumber that is equal to the textboxnumber.

Example
the value of textbox11 shoud be placed in sheetx, row 2, column K

Can anyone help me out with the proper code?

Any chance you could attach the workbook?
Easier to help with a tailor made solution if we can see that.

Click on GO ADVANCED, below your reply, and then scroll down to Manage Attachments to open the upload window.

BSB

Not tested as I don't have a sample file but something like this could work:

Please Login or Register  to view this content.

BSB

As I said, it's not tested, so let us know if you have issues with it.

You'll need to change CommandButton, Frame and Sheet names in the code to suit.

BSB

Done! Works like a charm, very grateful for your quick response.

Gr,
MamaExel

Glad I could help

No need to feel stupid. Sometimes it just needs a fresh pair of eyes.

BSB

Back again...

Can I adjust my request a little?

How should I ammend the code to have the values set on the first empty row on sheetx?

I've tried to get this done with "ThisWorkbook.Sheets("Sheetx").Cells(Rows.Count,1).End(xlup) +1" but cannot get it right.

Any help is appreciated.

Add this to the start of the sub:

Please Login or Register  to view this content.

Then change this line:

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

Does that work for you?

BSB

Hi BSB,

Actually I did exactly as you suggest but still get an error 13 / type mismatch on this line.

Please Login or Register  to view this content.

I've attached the wb, can you have a look and tell me what i'm missing?

Apologies mamaexcel! I was in a rush to get to a meeting when I was replying and missed a bit from the code line.
Try this:

Please Login or Register  to view this content.

BSB

Of course, that's it! Too bad I missed that.

Thanks again BSB, it works as I needed it to work.