Autofill form in word in combination with VBA

[nouki]

Hi !



I guess I need some help with my word document.

I would like to make a document for work. The format will be used so people can subscribe themself for a photoshoot.

There are many options, so they must tick one or more subjects they like.

My problem:
Every photoshoot has another time, example: a babyshoot takes about 3 houres and a marriage shoot takes about 1.5 houres.

I would like to have a textbox where stands automatically witch time they have.
Example: when they activate babyshoot, there must stand 3 houres. But when they take a babyshoot and a marriage shoot, there must stand 4.5 houres.

I have tried the 'if ... then' formule, but that didn't work, and I have no idea what's the right code for VBA.

I have attached the file, because it's a complex document

Hope you guys can help me !

[macropod]

For a form to be used by others, you should restrict your form to the use of formfields, since:
• they can be made to do calculations without the need for macros; and
• content controls require macro and are unusable on Macs.
Also, instead of using checkbox formfields, if you need to use a choice for calculations, you should consider using dropdown formfields.

[nouki]

I'm sorry, I don't understand, is there a difference between formfields? Where can I find the one you mean?

But when I choose for dropdown formfields instead of checkbox formfields, they can't choose multiple shoots..

[macropod]

Your document has content controls, formfields are quite different and are access via the 'Legacy Tools' button in the Controls group where you selected the content controls from.

[nouki]

Do I have to switch all content controls into formfields or only my checkboxes?
(In my word it's called Active X elements I guess )

There's a content control with an calender, but this is not possible to make it with a formfield, or is it?

[macropod]

As I have already said, content controls don't work on Macs. Besides which, formfeilds and content controls don't play well together. There isn't a calendar formfield, but you can format them for date input.

[nouki]

I have changed the checkboxes into Active X elements, see the attachement.

Actually, this is a trial format. The real format will be used by taking of psychodiagnostic instruments with psychiatric people (but I can't upload that format).
So I think that this format will not be used by someone who has a Mac (In Belgium, Mac is quite expensive )

But, I still have to use VBA for this, right?
is it possible with the 'if..then' string, now?

[macropod]

ActiveX controls don't work on Macs, either...

You can do the lot with formfields & formula fields, with no need for macros, and have a document that works equally well on PCs and Macs.

[nouki]

After a long search, I have found the legacy tools and I've changed my checkboxes into formfields.

What's next?

[macropod]

As I said in a previous reply, if you want the calculations to happen automatically without macros, you need to use dropdowns instead of checkboxes. I also said you shouldn't try to use content controls and formfields in the same document. Try the attached.