Sorry for the late follow up. I think the function you'll want to use in your formula is Switch(), which you can look up in VBA Help.

What I'm still vague on is *where* you want this value to appear -- the value that depends on the user's selection in the combo box.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"redruthann" wrote in message ...
EXACTLY - I have already calculated what I need - variables will only change
approx once a year - therefore, I do not need Outlook to do any calculations
- just display a given amount based upon selection.


{sorry about the craziness...just frustrated}

RUTHANN

"Sue Mosher [MVP-Outlook]" wrote:

Sorry but that's just gobbledygook the way the news server renders it. Are you saying that all you have is a single list of possible items to select, each one with a corresponding value? That there are in fact no arithmetic calculations to be performed?


"redruthann" wrote in message ...
Thank you Sue for responding.

Maybe this will help:

*ITEMS TO SELECT: VALUE TO DISPLAY WHEN ITEM SELECTED
01 GHG SH-PR 18.2m 2.73
02 GHG SH-NK 46m 6.00
03 GHG MD-PR 49.4m 7.41
04 GHG MD-NK 45.4m 6.81
05 GHG DB-PR 37.8m 5.67
06 GHG DB-NK 52.6m 7.89
07 COL SH-BT 18.2m 2.73

* The items to select are 1 item: 1 Item: 01 GHG SH-PR 18.2m
so....'item' is selected, but the value is displayed

I hope you can uderstand this!!

"Sue Mosher [MVP-Outlook]" wrote:

How complicated are your calculations? The reason I ask is that you may be better off writing VBScript code than writing complex formulas (without any way to debug them other than trial and error).


"redruthann" wrote in message ...
Hi....i hope someone can help...i'm going crazy about this

I would like a combobox that would display a certain $amt based on a
selection... Select Bridgeport - the amt of 5.00 appears.

For some reason I just can't seem to get it...I've searched all over, but
there is something that I am just not understanding.

I understand that there has to be data to be referenced agains. My problem
is 'populating'....I can add basic selections, but not to the extent for the
selection to display a different data. I'm not sure how to add
rows/columns...

PLEASE HELP

Ruthann