outlook combobox: value = x if A is selected

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

redruthann - 17 Mar 2006 00:34 GMT

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

Reply to this Message

Sue Mosher [MVP-Outlook] - 17 Mar 2006 02:28 GMT

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

Signature

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

> Hi....i hope someone can help...i'm going crazy about this
>
[quoted text clipped - 12 lines]
>
> Ruthann

Reply to this Message

redruthann - 17 Mar 2006 18:52 GMT

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

> 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).
>
[quoted text clipped - 14 lines]
> >
> > Ruthann

Reply to this Message

Sue Mosher [MVP-Outlook] - 17 Mar 2006 19:11 GMT

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?

Signature

> Thank you Sue for responding.
>
[quoted text clipped - 15 lines]
>
>> 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).

>>
>> > Hi....i hope someone can help...i'm going crazy about this
[quoted text clipped - 13 lines]
>> >
>> > Ruthann

Reply to this Message

redruthann - 17 Mar 2006 22:05 GMT

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

> 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?
>
[quoted text clipped - 35 lines]
> >> >
> >> > Ruthann

Reply to this Message

Sue Mosher [MVP-Outlook] - 27 Mar 2006 23:54 GMT

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.

Signature

> 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
[quoted text clipped - 5 lines]
>
>> 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?

>>
>> > Thank you Sue for responding.
[quoted text clipped - 34 lines]
>> >> >
>> >> > Ruthann

Reply to this Message

redruthann - 29 Mar 2006 16:34 GMT

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

> 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.
>
[quoted text clipped - 48 lines]
> >> >> >
> >> >> > Ruthann

Reply to this Message

Sue Mosher [MVP-Outlook] - 29 Mar 2006 20:26 GMT

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.

Signature

> 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.
[quoted text clipped - 4 lines]
>>
>> 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.

>>
>> > EXACTLY - I have already calculated what I need - variables will only change
[quoted text clipped - 45 lines]
>> >> >> >
>> >> >> > Ruthann

Reply to this Message