I have a Combo box on a userform. I need the dropdown to show 2 columns - but upon choice, I need it to show the second column.
Using Properties: I have ColumnCount: 2, BoundColumn: 2
This displays 2 columns in the DropDown - but uses column 1 still.
Thanks
Last edited by CRIMEDOG; 08-19-2011 at 09:45 AM.
Hello CRIMEDOG,
Set your BoundColumn to 1 and your TextColumn to 2.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
That works - but it runs into a new problem. Can you use vlookup in the 2nd column of a range?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks