Combobox info

[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

 

[Bob Phillips]

Dave

Range("A1") = Combobox1.Value

 

[daver676]

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.

.