Thread: Textbox Linked Cell

I have a userform that has a button that, when pressed, generates a new sheet with a name that is a concatenation of the text found within 4 textboxes on the same userform.

I have a cell on a spreadsheet ... LookupTables!F2 ... that receives the concatenised name of the new sheet just generated.

I have another Userform that has a textbox that, when text is entered into it, it needs to send that text to a particular cell in that newly generated sheet.

example :
if the newly generated sheet is called 13B1JAN2008DATA, then the textbox would send its text to 13B1JAN2008DATA!E10

if the newly generated sheet is called 15D20MAY2012DATA, then the textbox would send its text to 15D20MAY2012DATA!E10

whatever the new sheet is called, its name will be found in LookupTables!F2, and the text needs to be sent to cell E10 of whatever that new sheet is called.

Worksheets(Worksheets("LookupTables").Range("F2").Value).Range("E10").Value = Userform2.Textbox1.Text