LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Multiple column Combobox

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ComboBox Value Comparison from multiple worksheets Ed P[_2_] Excel Programming 0 February 16th 05 09:47 PM
Compare ComboBox Value from multiple Worksheets Ed P[_2_] Excel Programming 0 February 16th 05 02:53 PM
Multiple ComboBox Lists sailingdan[_3_] Excel Programming 3 July 12th 04 03:46 AM
Multiple combobox association Thunder5[_3_] Excel Programming 0 February 24th 04 12:51 PM
Multiple Column ComboBox using Additem Jimmi Excel Programming 2 September 24th 03 02:40 AM


All times are GMT +1. The time now is 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"