Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 122
Default Combo Box, show multiple columns

I have a combo box that references a list of 4 columns. I have the column
width property in the combo box set up as 50pt, 0pt, 0pt, 100pt so the list
shows the first and second columns of my list.

When I choose an option in the list I see the data in columns 1 & 4 like I
want:

Ex: 1234 Joe Smith

However after I select the person I only see the 1234 in the combo box
itself, how can I show both 1234 and Joe Smith after they have been selected?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,344
Default Combo Box, show multiple columns

Hi,

I'm not clear on this one, you have your columns set to 50, 0, 0, 100 and
then you say you see columns 1 and 2? I would expect to see 1 and 4.

You might try a concatenated single column display. For example the list
would display one column =Column1 & " - " & Column4

--
Thanks,
Shane Devenshire


"Melissa" wrote:

I have a combo box that references a list of 4 columns. I have the column
width property in the combo box set up as 50pt, 0pt, 0pt, 100pt so the list
shows the first and second columns of my list.

When I choose an option in the list I see the data in columns 1 & 4 like I
want:

Ex: 1234 Joe Smith

However after I select the person I only see the 1234 in the combo box
itself, how can I show both 1234 and Joe Smith after they have been selected?

Reply
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
My titles won't stay when i select columns to merge into a combo b Brenda Excel Discussion (Misc queries) 1 October 13th 08 02:10 AM
adding blank cells to multiple columns to show similarities Guest3731 Excel Discussion (Misc queries) 1 April 21st 08 06:22 PM
Combo Box - Show only first two digits? Gayla Excel Discussion (Misc queries) 7 November 8th 06 06:08 AM
Combo box in Excel that displays 2 columns ichu05 New Users to Excel 1 March 21st 06 08:32 PM
How does Excel Sheet with combo box show it when used projector? bparekh5 Excel Worksheet Functions 0 January 14th 06 06:19 PM


All times are GMT +1. The time now is 05:19 AM.

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

About Us

"It's about Microsoft Excel"