Gary,

I wasn't using an Active X control, but your recommendation will work for
me. I appreicate the tip. Thanks again.

Regards,

"Gary Keramidas" wrote in message
...
not exactly sure what you want, but change the column count to 2 in the
combo properties dialog

--


Gary Keramidas
Excel 2003


"CAM" wrote in message
...
Hello,

I am using Excel 2007 I am trying to use the combo box - form control. I
have the input range in a different sheet A1:B200 showing General Ledger
Number and Description. What I want the user to see is the General Ledger
number and description, but only show the account number when the user's
make their selection. Currently I am only seeing the General Ledger
Number when I am looking for a number. How do I do that?
For example:

GL Number Account Description
4550 Sales TMA
I want to see both when trying to make a selection

I just want to see only after selection has been made - 4550.

Thank you in advance.