Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it posible for a combobox to return the value of two or more
columns? I have a simple User form having a combobox with 3 or more columns that takes the data from sheet1 column A, B and C for example. When I run the form and open the combobox , it display all the 3 columns but the problem is when I select one record only the value of the first column is returned. UserForm1.ComboBox1.ColumnHeads = True UserForm1.ComboBox1.ColumnWidths = "50,50,50" UserForm1.ComboBox1.RowSource = "A2:C255" UserForm1.ComboBox1.ShowDropButtonWhen = fmShowDropButtonWhenAlways Is there a way for the combobox return the value of column A & column C for example (in a string)? Because the problem I have is that in column A I have duplicated records and I need column C for isolating the record I want. With only the first column if I do a VLOOKUP after I only stop on the first occurrence and there is no way to find the second occurrence Thanks JM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ComboBox Value Comparison from multiple worksheets | Excel Programming | |||
Compare ComboBox Value from multiple Worksheets | Excel Programming | |||
Multiple ComboBox Lists | Excel Programming | |||
Multiple combobox association | Excel Programming | |||
Multiple Column ComboBox using Additem | Excel Programming |