No, but I didn't want to go too far down the coding road only to find I was acting on the wrong premise. With Case Types, for example, the code presently only allows you to have one. Similarly, if you choose a Response Type, that type is removed from the next dropdown to prevent the same Response Type being chosen more than once. And, if the user goes back and changes a previously-selected Response Type, all subsequent Response Types that might have been chosen are deleted. Clearly, if users can switch Case Types, the current approach isn't going to work and responsibility for maintaining the nexus between Case Types and successive choices of Response Types may end up falling more heavily on the user.

I'm not sure what lies behind the error message you were getting, but it may cease to be an issue once the above is addressed.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Yes, only one Case Type should be chosen, but the user may make a mistake and want to switch it later. Doing that should delete all Response Types that may have been chosen. But changing a previously selected Response Type shouldn't delete all subsequent response types. Also, users should be able to choose Response Types out of order -- e.g., pick one for #3 and #6 before deciding on what to pick for #2 -- and if they do that, then the intervening numbers should be inserted as blank numbered paragraphs in the output at the bottom. (Btw, "Response Types" are really just "Responses" -- obviously just a name thing that I can change later, but just in case that affects how you're conceptualizing it.)

Thanks again for all of this!

The form already clears all responses if the Case Type is changed and responses can already be chosen out of order; what the code presently enforces is the deletion of subsequent responses if an earlier one is changed, since that invalidates the dropdown options for those subsequent responses. I suppose the code could be re-written to refresh the dropdown options for those subsequent responses, though.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

The basic functionality works when I choose "Common" or “MV Rear” for Case Type – I then choose a “Response Type” item from the current Response DD list, exit the DD list (by clicking somewhere else or hitting tab), and click yes at the prompt, and the numbered paragraph below is successfully populated with the text corresponding to the item chosen.

But if the Case Type is "MV Pedestrian Knockdown," choosing an item from the DD list adds a new paragraph below with no text.

I can't choose responses out of order - when I choose a response for #1 and then exit and click yes at the "Add new entry" prompt, a DD list appears for #2. If I choose an item from that list, exit, and click yes, a DD list appears for #3, etc. I don’t see a way of getting a DD list to appear next to any number other than the one after the list being exited.

Can there just be drop down list boxes next to every number, and the form below would show numbered paragraphs for only those drop down lists from which the user has actually made a selection? Doing it that way would seem to obviate the need for the “Add new entry” prompt.

When I change Case Types, all of the numbered paragraphs are cleared (which is good), but all of the DD lists are not -- sometimes the first DD list refreshes, sometimes the second, and sometimes the last. Then choosing an item from the list that has refreshed and exiting usually doesn’t work right – sometimes nothing happens, sometimes I get a run-time error 5941 “the requested member of the collection does not exist,” sometimes other things happen. When it does work, it populates paragraph 1 below, rather than a paragraph corresponding to the number that the DD list is next to, and there is no prompt to add a new entry (and a DD list does not appear next to the following number).

When I choose that type, I see four dropdown options:
• None
• PedKnock Statutes
• PedKnock Negligence Laundry List
• MORE TO COME
Are you running this on a Mac, or on a PC, when you encounter these issues?
You can choose them in any order. What you seem to want, though, is for the output order to be the initial dropdown order, regardless of the order in which the items are chosen. That would break the nexus between the dropdown selections and the output list. If I recode the macro so that subsequent entries are not deleted when changing a given response, it will be possible to go some way to addressing this by allowing users to change a previous response.
Yes, that would be possible, but surely you wouldn't want more dropdowns to be available for a given case type than the are valid responses!?
I'm not seeing that - all response dropdowns except the first are deleted and all response outputs are deleted, too. We can revisit that once the above issues are clarified.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I am running it on a PC. Yes, I see those DD list options too, but when I choose "PedKnock Statutes" or "PedKnock Negligence Laundry List," the corresponding text from the Excel spreadsheet is supposed to populate the appropriate paragraph below -- all I see is the paragraph number.

Not sure what you mean here, I can't choose them in any order (for example, no DD list appears next to #17 when I have only chosen responses for #1 and #2). I want to be able to (for example) choose a response for #2, then #17, then #24 (in which case the document at the bottom would just have "2. blah blah blah", "17. blah blah blah", and "24. blah blah blah" -- ideally (but not crucially) with blank paragraphs for the intervening numbers) and for the responses chosen for #2 and #24 not not to refresh/delete if I change the response chosen for #17.

One of the possible responses is "Other" - which can be the response to multiple questions. So there can never be more DD lists available than valid responses.

Hi all. It's been a couple of weeks since my last post replying to Paul. I've spent many hours trying to do this myself. I've tried methods described in other posts, downloaded sample files that I've tried to modify to suit my needs, etc., but I'm in over my head. I'd really appreciate it if Paul or anyone else can help further. Thanks so much - I know everyone who contributes here does so out of the goodness of their heart and nothing else - and I really appreciate it.