Expanding tables with calculating form fields?

macropod · #1 12-14-2016, 09:48 PM

Quote:

Originally Posted by Father

So Word doesn't have an option like Acrobat to put a "CLEAR FORM" button?

Not a huge... It's simple enough to do like you said.

No, though one could do that quite easily with a few lines of VBA:

Code:

Sub ClearForm()
Application.ScreenUpdating = False
ActiveDocument.Unprotect Password:=StrPwd
ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=False, Password:=StrPwd
Application.ScreenUpdating = True
End Sub

Father · #2 12-15-2016, 03:08 PM

Is there a way to assign which cell the mass amount goes into?
Right now it all goes to the same cell.
If you add a row and select the other option, after the alert boxes have been filled in, the results for the mass go into the cell in the first row.

Quote:

Originally Posted by macropod

No, though one could do that quite easily with a few lines of VBA:

What is the trigger for that? Does it clear it when you open the form?

macropod · #3 12-15-2016, 04:09 PM

Quote:

Originally Posted by Father

What is the trigger for that? Does it clear it when you open the form?

The trigger is the user choosing to clear the form by running the macro (e.g. via a keyboard shortcut that you might assign). I doubt you'd want it to run every time you open the document...

If you're wanting pristine documents to work with, save one as a Word template (i.e. File>Save As>Save As Type:Word Macro Enabled Template (*.dotm)), then create new documents from that. See:
https://support.office.com/en-us/art...2-1191BCE57DEB
http://word.mvps.org/FAQs/Customizat...platePart1.htm

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to keep formatted form fields after mail merge or replace text with formatted form fields	jer85	Word VBA	2	04-05-2015 10:00 PM
Tables with form fields	step10	Word	18	11-12-2013 02:27 PM
Enable editing in expanding fields	marweste	Word	11	10-21-2013 07:41 AM
How to prevent Tables from expanding	HappyFingers	Word	1	11-29-2010 01:54 PM
Calculating Form Fields in Microsoft Word	wubba80	Word	1	06-25-2010 12:42 AM