Populate spreadsheet cell with data from textbox without using a cmdbutton

Hi there,

I have an Excel spreadsheet with a userform with 5 textboxes.

I need to insert a value in Textbox1 and it must populates cell A1 in the spreadsheet

I have other 4 cells in the spreadsheet that are populated with vlookups formulas based on the information in cell A1

Then i need to populate the remaining 4 textboxes in the userform with the data in the 4 cells in the spreadsheet

All of this without using a cmdbutton. Meaning i just need to insert different data in textbox1 to change the other 4

Can anyone help me?

I've attached my WB