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

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

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



"Bob Phillips" wrote:

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