Try the attached. Because your table has merged/split rows and the formfield that triggers the macro isn't in the last column that contains one, a different approach is required. I've also added the code required to handle your row-based formula fields.
In the code, you'll see a commented-out line with:
RngSel.FormFields(1).ExitMacro = ""
When you're satisfied the form is ready for release into production, un-comment that line. This will prevent the macro from being triggered by any except the last 'Reason' formfield in the table.
Note that I've streamlined your other macros, too.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|