Just link the List via its properties, and the value then shows in that
cell.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"The Narcissist" wrote in message
...
I have a worksheet with 3 columns namely Emp #, Department and Name. In
another worksheet, I have a listbox which allows the user to select the
Emp #
for generating a report. Is there a way I can have the employee name
reflect
directly in the linked cell for the listbox?

Thanks,

Sam