List Boxes with Values

[winter4400]

Hello,



I am trying to simplify an employee contract using Word 2010 and hope to get rid of a uniform deduction spreadsheet. It doesnt matter if this can be done in either a list box, or drop menu. I am hoping to choose the Qty and when I choose the Uniform the Total will automatically appear.

Column 1 is "Qty" and has the numbers 1-12

Column 2 is "Uniform Type" and it will list the Uniforms here is an example

Fleece Jacket $34.85ea
Grey T-Shirt $9.25ea
Charcoal Work Pant $27.50ea

Column 3 is "Total" I need this to calculate the Qty x the value of the Uniform Type. i.e If the employee took 2 Grey T-Shirt the total would show up as $18.50

[macropod]

For an example of how this kind of thing can be done using formfields, see the attachment at: https://www.msofficeforums.com/word-vba/14097-how-link-checkbox-change-nearby-cell-value.html#post39327

[winter4400]

That is close Macropod. This is why I posted a new Thread, seems everything I find is close but not right. In your example I would have to know the Item and it's price and manually type it in. What I would like is to pick the Item from a drop down list and it auto-populate the price for the item picked.

[macropod]

Hi winter,

It's easy enough to use dropdown formfields to select the items, textbox (or dropdown) formfields for the quantity, and have formula fields calculate the values. The document in the link, naturally enough, was tailored to suit the poster's needs in that thread.

For something closer to your needs, see attached.

[winter4400]

Here is what I am trying to do. I think it all works and I will add lines once I get it all figured out but for some reason I cannot get it to total.

[macropod]

Hi winter,

Instead of { =qty1*b5 \# "$#,##0.00;($#,##0.00)" }, your 'total' formula should read {={REF Qty1}*E2 \# "$,0.00"}

You need to use a REF field to retrieve the Qty dropdown's value, with the field braces for it (ie '{ }') created via Ctrl-F9. Your 'b5' reference is also wrong - it refers to row 5 in the 'Item' column. As for your numeric picture switch, there's no reason to provide for negative values and the # characters are only of any benefit for padding out the field when the value is less that 1,000. Even so, that padding doesn't give a character spacing equal to what you get when the missing digits are supplied. If you want to enforce right-alignment, use a tab after the $ symbol in the field code and insert either a right-tab or decimal-tab in the cell(s) concerned.