Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Milti Column Combobox
I have a form with a multicolumn combobox (CBNames). it gets its list from
columns a, B, and C of a worksheet. (Number, FirstName, LastName) i have the column count set at 3, and the column widths set appropriately. when a user clicks the arrow to "Drop Down" the combobox, and he/she selects an item from the list, what is shown in the box is just the number, the first column. is there a way to get it to display all 3 items for that row in the combobox after it is selected? TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Milti Column Combobox
you can select 1 column to be displayed when the combobox is not 'dropped'. You do this by setting the TextColumn = 2 and it will show the second column. To display the concatenated name you'd have to include a fourth column with the data you want displayed. If you dispense with the convenience of using ListFillRange but populate the combo's list yourself then you dont need need to change your actual data. Sub Combofill() Dim itm As Range With Me.ComboBox1 'this ought to be set in designer .ListFillRange = "" .ColumnCount = 4 .ColumnWidths = "18pt;72pt;72pt;0" .BoundColumn = 1 .TextColumn = 4 'this would normally run .Clear For Each itm In Range("a1:a40") If itm(1, 1) < "" Then .AddItem itm(1) .List(.ListCount - 1, 1) = itm(1, 2) .List(.ListCount - 1, 2) = itm(1, 3) .List(.ListCount - 1, 3) = itm(1, 2) & ", " & itm(1, 3) End If Next End With End Sub -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Virginia wrote : I have a form with a multicolumn combobox (CBNames). it gets its list from columns a, B, and C of a worksheet. (Number, FirstName, LastName) i have the column count set at 3, and the column widths set appropriately. when a user clicks the arrow to "Drop Down" the combobox, and he/she selects an item from the list, what is shown in the box is just the number, the first column. is there a way to get it to display all 3 items for that row in the combobox after it is selected? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VBA Multi Column ComboBox | Excel Discussion (Misc queries) | |||
Multi Column ComboBox | Excel Programming | |||
Populate Column Header on ComboBox | Excel Programming | |||
Filename and creation timestamp in 2-column combobox | Excel Programming | |||
Multiple Column ComboBox using Additem | Excel Programming |