Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #14  
Old 11-15-2018, 05:01 AM
macropod's Avatar
macropod macropod is offline Macro to add row to table in a Word form Windows 7 64bit Macro to add row to table in a Word form Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,512
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, 146 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to add row to table in a Word form Macro help sought for Word table xan Word VBA 1 04-20-2012 07:50 PM
Macro to add row to table in a Word form Create Table Form from Word Document gsj224 Word VBA 3 07-31-2011 09:26 AM
Macro to add row to table in a Word form Word Macro That Checks a Check Box Form Field When File Print is Executed DKerne Word VBA 4 06-09-2011 11:54 AM
Do I need a Form or a Macro?? Keith24249 Excel 0 08-23-2010 06:23 AM
Use Form Checkbox to Add Table laxonator Word Tables 0 10-23-2008 06:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft