Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox Row Source
I have a combobox on a userform that has a Row Source of 3 columns and about
200 rows. I can get everything to work but the combobox will only display the entry from the first column of the source. I would like it to display the second column. I have tried changing the Bound Column to 2. In fact, I have changed it to 0, 1, 2, and 3 and the combobox always displays column 1 information. I can get it to work by shifting the columns around in my source data, but I would like to avoid that if at all possible. I am running Excel 2002. Does anyone have any suggestions? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox Row Source
You need to set the TextColumn property to 2 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox Row Source
Set the ColumnCount = 2 and ColumnWidths = 0
That will display two columns in the combo, but make the first column zero points wide, giving the appearance that there is only one column in the list. Use BoundColumn to change which column is selected...Combobox1.Value and a BoundColumn = 2 returns the item from the 2nd column of the selected row. -- Tim Zych www.higherdata.com Compare data in worksheets and find differences with Workbook Compare A free, powerful, flexible Excel utility "Martin" wrote in message ... I have a combobox on a userform that has a Row Source of 3 columns and about 200 rows. I can get everything to work but the combobox will only display the entry from the first column of the source. I would like it to display the second column. I have tried changing the Bound Column to 2. In fact, I have changed it to 0, 1, 2, and 3 and the combobox always displays column 1 information. I can get it to work by shifting the columns around in my source data, but I would like to avoid that if at all possible. I am running Excel 2002. Does anyone have any suggestions? Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox Row Source
That worked. Thanks.
"Smallweed" wrote: You need to set the TextColumn property to 2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox Row Source across ALL sheets | Excel Programming | |||
ComboBox Row Source across ALL sheets | Excel Programming | |||
Combobox source | Excel Programming | |||
combobox row source | Excel Programming | |||
Combobox list source | Excel Programming |