Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
| Search | Today's Posts | Mark Forums Read
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
  #1 (permalink)  
Old October 17th, 2007, 05:04 PM
Authorized User
 
Join Date: Apr 2007
Location: , , .
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default Combo Box Show all bound columns

Is there any way to make a combo box show all of the bound columns after the user selects an item from the list? I have three colums in the list which it shows, but once the user selects and item, only the bound column item is showing in the combo box.

I know how to get my data from the bound columns with no problem, but the users want to see the info from all three columns for the item he/she has selected before they proceed.

Thanks for any help you may have.
Coby.

  #2 (permalink)  
Old October 18th, 2007, 01:35 PM
Friend of Wrox
Points: 513, Level: 8
Points: 513, Level: 8 Points: 513, Level: 8 Points: 513, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2007
Location: Davenport, IA, USA.
Posts: 163
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Create some text boxes that will show the other values which update on change of combo box.

Or you could set the value = all 3 values separated somehow (a ; for instance). There is no setting to display them by default. The drop down can show multiple fields when extended, though, which comes in handy.

  #3 (permalink)  
Old October 22nd, 2007, 02:24 PM
Authorized User
 
Join Date: Apr 2007
Location: , , .
Posts: 56
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Great!. Thanks, I will probably do your second idea as well as the text boxes, but hide the text boxes and grab the values from them. Right now I am actually grabbing the value of the text box and using it.





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
Combo Box to Show Multi Column Info After Select Coby Excel VBA 0 August 14th, 2007 05:23 PM
Show all values in a combo box in a report Odeh Naber Access 3 July 24th, 2007 07:37 AM
Data type mismatch -- Combo box bound to database jamenijamjam Beginning VB 6 2 September 1st, 2006 08:36 PM
combo box with 2 columns mjuliao Access 1 October 19th, 2005 10:31 AM





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