Listbox Properties

[The Narcissist]

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

 

[Bob Phillips]

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]

Hi Bob,

I've done that. But I want a value other than the ones showing in the list.
It's something like this.

A B C
Emp # Name Department

The source for the listbox is column A. But the value I want displayed in
the linked cell is the corresponding value from Column B. Is there a way this
can be done?

Thanks,

Sam