put dynamic info into comments

[nlehman02]

On my main sheet I have a column that shows different departments (A
and another column that shows the number of employees (B) in tha
department. The number of employees is found from the main list o
employees found on another sheet in the workbook. I was wondering i
there was anyway to show the names of the employees referenced from th
second sheet in a pop-up box of some sort whenever the numbe
cell(B1:Bx) is selected.

Any help appreciated.

Natha

 

[Frank Kabel]

Hi
not possible with comments. this would require an event macro (e.g.
selection change)