Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I retrieve an item from a multicolumn combobox? I need the value from
the second column. However, I need the box to display the value in the 1st column. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Use the BoundColumn Property of the COmbobox (check the online help about this property) Also you can access any element with cbx1.List(row,column) and replacing row by cbx1.ListIndex -- Regards, Sébastien <http://www.ondemandanalysis.com "ImCary" wrote: How do I retrieve an item from a multicolumn combobox? I need the value from the second column. However, I need the box to display the value in the 1st column. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Im,
create a textbox control ControlSource -- = combobox_controlname.column(1) column 1 is actually column 2 since column indexing starts with 0 make sure the ColumnCount property of the combobox is set to something besides 1 the ColumnWidths property controls how the columns display ..5";2" -- first column is .5" and second column is 2" seperate column widths with semi-colon the ListWidth property should be the sum of the ColumnWidths Have an awesome day Warm Regards, Crystal ImCary wrote: How do I retrieve an item from a multicolumn combobox? I need the value from the second column. However, I need the box to display the value in the 1st column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
retrieving data | Excel Worksheet Functions | |||
Retrieving data from the web - help ! | Excel Worksheet Functions | |||
Retrieving stock data | Excel Discussion (Misc queries) | |||
Retrieving Web Data | Excel Programming | |||
Retrieving data | Excel Programming |