Combo Box - Form Control

[CAM]

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.

 

[Gary Keramidas]

not exactly sure what you want, but change the column count to 2 in the
combo properties dialog

 

[CAM]

Gary,

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

Regards,