I have a form with a series of comboboxes which contain eight items.
Each of the boxes contain the same expense account titles. The user
selects an account title and places a value in the next column like
"lunch" and $12.50.

When the worksheet is completed, it is emailed to the accounting dept.
My problem is that the selected item is not displaying its value
(lunch) only the $12.50.

I am using Excel 2003. How do I store the selected value?

Thanks,
Don in Montana

Have you asigned the ComboBox a Linked Cell?

Is the ComboBox on a Form or on the Worksheet, is it a ControlToolBox
ComboBox or Form ComboBox?
The ComboBox needs to have a Cell asigned to it to place the selected value
there.

"HappySenior" wrote in message
...
I have a form with a series of comboboxes which contain eight items.
Each of the boxes contain the same expense account titles. The user
selects an account title and places a value in the next column like
"lunch" and $12.50.

When the worksheet is completed, it is emailed to the accounting dept.
My problem is that the selected item is not displaying its value
(lunch) only the $12.50.

I am using Excel 2003. How do I store the selected value?

Thanks,
Don in Montana