Macro to Skip Calcuation if Field is Blank?!

Elan05 · #6 04-26-2013, 08:10 AM

My document does have other macros in it. Does that mean I can't use the calculation feature in the fields? I created the following calculation (made sure it worked in Excel before transferring over to Word).

=IF(Cycle="Annually", "Year1"/1, IF(Cycle ="Semiannually", "Year1"/2, IF(Cycle ="Quarterly", "Year1"/4, IF(Cycle ="Monthly", "Year1"/12, IF(Cycle ="Bimonthly", "Year1"/6, IF(Cycle ="Triannually", "Year1"/3,0))))))
When I protected the document and tabbed through the fields, it skipped over the field with the formula and didn't calculate anything. Also, the default of the form field with the calculation was showing "$t:00" Which is another issue... I can't have anything showing as a default because if there isn't anything entered in the fields, I want the printed document to look like those fields don't exist.

Going back to the macro by Fumei - does "docFF" need to be changed to ActiveDocument.FormFields? since that is what I am referencing?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to remove blank column	netchie	Word VBA	4	03-14-2013 02:22 PM
Email macro to read range for .To field	MattMurdock	Excel Programming	2	08-07-2012 06:46 AM
Assign macro but hide the button/field	trlear	Word VBA	5	02-23-2012 04:35 PM
Form Fields - Create blank form text field with if statement?	LAssist2011	Word	5	12-14-2011 03:02 PM
How to turn all blank lines into non-blank for legal forms	sieler	Word	3	04-12-2009 01:38 PM