I'm not sure with a form combo box, but you can using a combo box from the
control toolbox.

Once you have drawn it and placed it on the screen, right mouse click,
select properties, look for ListFillRange, you can put your cells range
there.

You can link your cell using LinkedCell

To test, click exit design menu button on control toolbox.




--
This post was created using recycled electrons!


"Gloria" wrote:

I want to have a combo box in my excel spreadsheet. The problem is that I
need to have two columns; however, when I create it, I just have the values
in the first column. Is there any way I can have my combo box that shows the
values for both columns? For instance, I have column A that has code numbers
and a column B that has the description of the codes. When I create my combo
box, I would like to click in the drop down arrow and see the code as well as
the description. However, when I choose the code, I would like to show just
the code on my cell.