ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Display info in Combo box'es (https://www.excelbanter.com/excel-programming/377684-display-info-combo-boxes.html)

[email protected]

Display info in Combo box'es
 
Hi all

I have a problem, I have one userform with a couple of combo boxes I
have the following settings in the combo box

Bound Column 1
Column Count 2
Column Width's 0 pt;100 pt

In my fist column I have the Id's and in the second one I have the
description, the thing is that when I choose an item it displays the Id
and not the description, it is strange because on my other combo box'es
it does not hapend.

I try to delete and get a new one but it did not fix the problem

Any Ideas

Thanks


Tom Ogilvy

Display info in Combo box'es
 
Boundcolumn: 2

first column is column 1 in boundcolumn property.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Hi all

I have a problem, I have one userform with a couple of combo boxes I
have the following settings in the combo box

Bound Column 1
Column Count 2
Column Width's 0 pt;100 pt

In my fist column I have the Id's and in the second one I have the
description, the thing is that when I choose an item it displays the Id
and not the description, it is strange because on my other combo box'es
it does not hapend.

I try to delete and get a new one but it did not fix the problem

Any Ideas

Thanks




[email protected]

Display info in Combo box'es
 
Hi Tom

The thing is that if I put boundcolum 2 it will enter the description
and not the id, correct me if ia am wrong.

Tom Ogilvy ha escrito:

Boundcolumn: 2

first column is column 1 in boundcolumn property.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Hi all

I have a problem, I have one userform with a couple of combo boxes I
have the following settings in the combo box

Bound Column 1
Column Count 2
Column Width's 0 pt;100 pt

In my fist column I have the Id's and in the second one I have the
description, the thing is that when I choose an item it displays the Id
and not the description, it is strange because on my other combo box'es
it does not hapend.

I try to delete and get a new one but it did not fix the problem

Any Ideas

Thanks




All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com