TextBoxes

Hi Guys,
I want to change the contents in .....say five text boxes depending on the Employeename i type in the first textbox.
Eg: I have 6 textboxes and when i type the name of the employee in the first textbox then the rest of the five textboxes should automatically have all his information as i type. I know you guys could help me out on this one. Thanks in advance,
Derek

in the text1_change protocol, enter the following code:

private Sub Text1_change
'I assume the names of the textboxes are text2, text3, text4, etc...
text2.text = text1.text
text3.text = text1.text
text4.text = text1.text
text5.text = text1.text
text6.text = text1.text
'If you don't want their text to be overwritten, meaning it is added on, enter the following code:
text2.text = text2.text & text1.text
text3.text = text3.text & text1.text
.
.
.
text6.text=text6.text & text1.text

is this what u wanted to know?

Private Sub Text1_Change()
Text2 = Text1
Text3 = Text1
Text4 = Text1
Text5 = Text1
End Sub