|
|
outlook combobox: value = x if A is selected
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 |
outlook combobox: value = x if A is selected
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 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 ... 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 |
outlook combobox: value = x if A is selected
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]" 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). -- 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 ... 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 |
outlook combobox: value = x if A is selected
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 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 ... 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 |
outlook combobox: value = x if A is selected
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? -- 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 ... 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 |
outlook combobox: value = x if A is selected
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 |
outlook combobox: value = x if A is selected
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]" wrote: 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 |
outlook combobox: value = x if A is selected
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 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 ... 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]" wrote: 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. "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 |
| All times are GMT +1. The time now is 11:14 AM. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com