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 Keramidas
Excel 2003


"CAM" <(E-Mail Removed)> wrote in message
news:6DAF90A5-34E3-4EC6-ADF2-(E-Mail Removed)...
> 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,

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

Regards,

"Gary Keramidas" <(E-Mail Removed)> wrote in message
news:%23rF5%(E-Mail Removed)...
> not exactly sure what you want, but change the column count to 2 in the
> combo properties dialog
>
> --
>
>
> Gary Keramidas
> Excel 2003
>
>
> "CAM" <(E-Mail Removed)> wrote in message
> news:6DAF90A5-34E3-4EC6-ADF2-(E-Mail Removed)...
>> 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.
>