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

I've done that. Tanks, but teh data from cells D5 to D11 doesnīt populate the remaining 4 textboxes.

Any value. Try 900. It populates cell D3 and the formulas in cells D5, D7, D9 and D11 are working fine. But then, the data in those cells should populate textboxes 2 threw 5 and that isn't working.

But if i do that it eliminates the spreadsheet formulas...I canīt seem to find a way out.

Norie, Thanks in advance. I've found that if i close the userform, and then open it again, the information is correct. However, i need the information to update automaticaly when i change data in textbox1 without having to close de userform. is this possible?

Fantastic. It works great. Thanks a lot Norie.