Transfer Data From Userform Textbox to Specific Cell

Hi all

I was wondering if someone could help me. I have the following code, which passes the value of a textbox to a specific cell on a worksheet using range. However, I would like to amend the code so the range which states the cell is based upon the value of another textbox. So in the below example, the information from Textbox RS1 passes into cell F2 on the 'Inbox Rota' worksheet. What I want is a second textbox, lets call it RS2, which states the cell I want RS1 to post to. For example RS2 states 'A2'. So I want the code below to base which cell on the worksheet it passes the value of RS1 onto based on the value in RS2.

Please Login or Register  to view this content.

I hope that makes sense.

Thanks in advance for your help.

May be

Please Login or Register  to view this content.

Can you upload sample of your workbook?

This code doesn't transfer from the textbox to a cell, it does the opposite by putting the value from F2 on 'Inbox Rota' in RS1.

Please Login or Register  to view this content.

If you wanted to put the value from RS1 into a cell based on the value in RS2 the code would look something like this

Please Login or Register  to view this content.