Macro driven excel form to embed into Word

[koticphreak]

Hello,


So I have an excel form that has a question, you answer the question with a drop down and the next question (and next drop down box) is populated based on your answer. I'd like to get something similar into Word, but it seems extremely difficult to do this in word. I've found this post:

http://www.vbaexpress.com/forum/show...p-Down-Changes

But it seems like adding a question and then another drop down and then monitor that dropdown is more work than it's worth. Any input?


Thanks in advance!

[Tinbendr]

Decide which control you can live with (I prefer Formfields, ActiveX, then content controls). Then come back with a specific question.

In the meantime, visit Greg Maxey's site for more info.

[macropod]

Not at all difficult. For example, create two dropdown content controls. Give one the title 'Master', the other the title 'Slave'. Populate the 'Master' with:
Option1
Option2
Option3
Option4

Then add the following macro to the document's 'This Document' module. Having done so, select an entry in the 'Master' then look at the options in the 'Slave'. Repeat until you get bored.

Please Login or Register  to view this content.

Something similar could be done with dropdown formfields, but content controls are more flexible. Avoid ActiveX controls if your document might ever need to be used on a Mac - they're not supported on that platform.