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" <(E-Mail Removed)> wrote in message
news:f1eb19a2-0154-447e-bbc4-(E-Mail Removed)...
>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