Combo Box Question

wendell42

Board Regular
Joined
Feb 10, 2005
Messages
136
I am trying to create a worksheet to calculate travel expenses. I want to put several combo boxes on the sheet for the payment method. I would like the combo box to show in the drop down: Cash, Personal Credit Card, Procurement Card. To complicate things a bit more, I would like the following to actually fill in the box: If Cash is selected, the box will show CA, if Personal Credit Card is selected the Box will show CC and if Procurement Card is selected, the box will show PC.

Basically when the drop down appears it will show the full text, but when one option is selected, it will display the two letter result.

Hope someone can help me with this one.

Thanks in advance!

Wayne
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

sunnyland

Well-known Member
Joined
Jan 27, 2006
Messages
912
Hello there,

Sometimes people are trying to do things the cumbersome way.

Looking at your problem, I found an easy solution that will do not exactly what you request but near enough.

To try out this code:
Type in A1:b3

C Cash
CC Personal Credit Card
PC Procurement Card

Put a combo on the worksheet.
Right click on it and select properties there change these properties as follow:

boundcolumn 1
columncount 2
listfillrange A1:B3

That is it.

Meaning your combo will display 2 columns but after selection by the user, the first column will be the value.

I think this is pretty similar to what you want and pretty easy to implement.
 

Forum statistics

Threads
1,136,989
Messages
5,678,975
Members
419,796
Latest member
doctorgresham

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top