View Single Post
 
Old 11-15-2018, 05:01 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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.
Attached Files
File Type: docm Table.docm (34.7 KB, 138 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote