Combo Box - Form Control

  • Thread starter Thread starter CAM
  • Start date Start date
C

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.
 
not exactly sure what you want, but change the column count to 2 in the
combo properties dialog
 
Gary,

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

Regards,
 
Back
Top