Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Excel-Combo box

I want to have a combo box in my excel spreadsheet. The problem is that I
need to have two columns; however, when I create it, I just have the values
in the first column. Is there any way I can have my combo box that shows the
values for both columns? For instance, I have column A that has code numbers
and a column B that has the description of the codes. When I create my combo
box, I would like to click in the drop down arrow and see the code as well as
the description. However, when I choose the code, I would like to show just
the code on my cell.
 
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
create combo box in excel Vinay Excel Discussion (Misc queries) 1 December 29th 06 11:20 AM
How do I get a combo box to calculate percentages in Excel? Pattid175 Excel Worksheet Functions 4 April 23rd 06 05:12 PM
List box or combo box on an Excel spreadshee... city Excel Worksheet Functions 1 April 7th 05 09:31 PM
Why can't I insert a Combo Box in Excel? mpatters Excel Discussion (Misc queries) 1 April 6th 05 11:07 PM
How do I apply a combo box to multiple cells in Excel so that it . DB Excel Discussion (Misc queries) 1 January 12th 05 03:42 PM


All times are GMT +1. The time now is 12:04 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"