word, find values from checkboxes listboxes and textfields, and calculate

[OTWarrior via OfficeKB.com]

I have a rather complicated document that uses check box, text boxes, and
drop down fields.

I need a calcuation box that works out which value in the 1st drop down box
(es) [there can be more than one row with the same value, that needs to be
added to the calculation], adds the value of the checkbox (there are 7 of
them, and they need to have a value set) and multiply those checkboxes value
against that of another listbox.

is this possible? or too complicated to do in word? (or is my explaination a
shamble

 

[Cindy M.]

Hi OTWarrior,

I have a rather complicated document that uses check box, text boxes, and
drop down fields.

I need a calcuation box that works out which value in the 1st drop down box
(es) [there can be more than one row with the same value, that needs to be
added to the calculation], adds the value of the checkbox (there are 7 of
them, and they need to have a value set) and multiply those checkboxes value
against that of another listbox.

is this possible? or too complicated to do in word? (or is my explaination a
shamble

Well, it's lacking some information, in any case:

1. Version of Word?

2. From which toolbar were these fields inserted?

FWIW, it can probably be done, although I don't understand all the details
about exactly what you want to do.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[OTWarrior via OfficeKB.com]

sorry, it's word 2002 and it's the "forms" toolbar, not the "control toolbox"

Hi OTWarrior,

I have a rather complicated document that uses check box, text boxes, and
drop down fields.

[quoted text clipped - 7 lines]

is this possible? or too complicated to do in word? (or is my explaination a
shamble

Well, it's lacking some information, in any case:

1. Version of Word?

2. From which toolbar were these fields inserted?

FWIW, it can probably be done, although I don't understand all the details
about exactly what you want to do.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Cindy M.]

Hi OTWarrior,

sorry, it's word 2002 and it's the "forms" toolbar, not the "control toolbox"

I need a calcuation box that works out which value in the 1st drop down box
(es) [there can be more than one row with the same value, that needs to be
added to the calculation], adds the value of the checkbox (there are 7 of
them, and they need to have a value set) and multiply those checkboxes value
against that of another listbox.

Well, from the description I'd say you need to loop through the formfields in
a given range (not sure if the entire document, or some smaller part is
relevant). Check that it's the right "kind" of field (a naming convention
would probably be useful for this), then get the value. To get selection
showing in a dropdown field, use the Result property:

ActiveDocument.FormFields(1).Result

A checkbox can't store a value, so I assume you mean that certain values are
associated with certain checkboxes. Again, I'd probably use a naming
convention to carry that information. To find out whether a checkbox is
checked:

ActiveDocument.FormFields(1).CheckBox.Value

I have a rather complicated document that uses check box, text boxes, and
drop down fields.

[quoted text clipped - 7 lines]

is this possible? or too complicated to do in word? (or is my explaination a
shamble

Well, it's lacking some information, in any case:

1. Version of Word?

2. From which toolbar were these fields inserted?

FWIW, it can probably be done, although I don't understand all the details
about exactly what you want to do.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail