Template question

[vulcanuck]

I'm trying to create an interface (or form) that will create a letter document. The interface would consist of three drop down menus (or check boxes, or whatever) and a submit button. The user would pick the location from the 1st drop down and a general activity at that location from the 2nd.

A third drop down would choose the specific activity filtered from the users choice in drop down 2. For example, choosing Activity A in the 2nd drop down gives the user specific options like Activity Aa, Activity Ab, etc.

Once submitted, or saved, or whatever, the letter would be composed based on those choices.

Ok, how do I do that? Can it be done? Can it be done by a regular, non-IT type person aka me?

[macropod]

Yes, it's possible, but whether you could do it depends on your abilities with vba programming.

[vulcanuck]

My VBA is non-existent. Is there a cheat sheet out there somewhere, or is it better that we get someone in who can do this for us?

[macropod]

To see what's involved, check out the item 'Cascading Listboxes' at: http://gregmaxey.mvps.org/word_tip_pages/populate_userForm_listbox_or_combobox.html
and that's just for your pre-document userform. you then need to add the code to create the document and use the output from your userform as the basis for generating the document's content. This is not beginner stuff and I doubt you'll find many programmers who would be willing to do it for free.