Combobox info

  • Thread starter Thread starter daver676
  • Start date Start date
D

daver676

Hello

I have a combobox containing names of employees. Once the
user of the form has selected the appropriate employee
name, I need that name to be copied to a cell in another
worksheet automatically. I have tried it once using
the "Link cell" option in the properties box, but it only
returns a number in the linked cell, not the actual name.
How can I get it to post the actual name?

Thanks!

Dave
 
Thanks Mark. Worked good for what I needed.
-----Original Message-----
You can also use the INDEX function to bring back the
actual name. In the cell where you want the actual name to
appear type =INDEX(A1:A10,K1)

In the above example A1:10 is the range of cells that
contain your choices for the Combo Box and K1 is the
reference of the cell that you have chosen as the Linked
Cell.

.
Click to expand...
 
Back
Top