Combo Box Question

[wendell42]

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

 

[sunnyland]

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.