Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 14th, 2007, 05:23 PM
Authorized User
Join Date: Apr 2007
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default Combo Box to Show Multi Column Info After Select

I am using a form which has a combo box with drop down list. Well, I have three columns in my list just as I want and I am having no
trouble getting the correct info by using the bound column

However once I make a selection from the dropped down list the combo
box only displays the item from the first columns. Is there a way to show all three of my items from all three of my columns.

For example, let's say my drop down list shows the following list of
choices each of which come from three columns:

2x4 Spruce fir Borate Treated 24SFBT
2x6 Spruce fir Borate Treated 26SFBT

So, lets say I click select the first item row (2x4 Spruce fir
Borate Treated 24SFBT)

When the combo box updates, the only info it shows to the user is: 2x4
Spruce fir

Is there a way to let it show the entire: 2x4 Spruce fir Borate
Treated 24SFBT ????


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi Column Combo Box in Datagrid View Columns HemaChaudhry Visual Basic 2005 Basics 1 September 20th, 2007 07:51 AM
Multi-column combo box in datagridview aad1 C# 0 June 5th, 2006 09:58 AM
Multi column combo lists c_olinrb Access 4 July 21st, 2005 09:21 AM
multi-column combo myth12345 VB How-To 1 January 3rd, 2005 04:29 PM
Multi Select Combo Box acdsky VB How-To 2 March 1st, 2004 03:09 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.