Hi,

I have one problem in create a data in userform.

The problem is:


1) I want to type the staff ID and the name will appear. I try to use
function "If" but its limited to 64 k only for every function. I also
use vlookup and link to the sheet. But still have a error. Please
guide me. Thank You

Example:

Staff Id : 010035
Name : Automitacally appear when i type a staff Id
(this scenario in user form, not in sheet)

Can anybody provide the code