<o>Hello,
If I had for example on Sheet 1 a textbox and some labels like "ID-Name-date-Phone"
and on Sheet 2 is all the employees Information based on the same labels as in Sheet 1
What I want to do is, when someone types the employee ID in the textbox on sheet 1 and presses enter,
It would take the entered employees ID information "Name-Date-Phone" on sheet 2 and show them on sheet1 under the same labels.
Clarification: Not showing the information on the text box, but on other cell columns on sheet 1.
Extra Question: is it possible to be done with a Listbox also?
</o>
If I had for example on Sheet 1 a textbox and some labels like "ID-Name-date-Phone"
and on Sheet 2 is all the employees Information based on the same labels as in Sheet 1
What I want to do is, when someone types the employee ID in the textbox on sheet 1 and presses enter,
It would take the entered employees ID information "Name-Date-Phone" on sheet 2 and show them on sheet1 under the same labels.
Clarification: Not showing the information on the text box, but on other cell columns on sheet 1.
Extra Question: is it possible to be done with a Listbox also?
</o>