outlook combobox: value = x if A is selected

[redruthann]

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

 

[Sue Mosher [MVP-Outlook]]

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).

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[redruthann]

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!!

Thanks
Ruthann

 

[Sue Mosher [MVP-Outlook]]

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?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[redruthann]

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]]

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[redruthann]

The value of the selection would appear in another field, let's say the
'mileage' field. Perhaps I am going about it in the wrong way.

Ruthann

 

[Sue Mosher [MVP-Outlook]]

In that case, you'd put a formula on the Mileage field's control that uses Switch, e.g.:

Switch(Left([YourFieldName], 3) = "<01", 2.73, Left([YourFieldName], 3) = "<02", 6.0)

I'll leave it to you to fill in as many other terms for Switch as you need.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers