Macro to Skip Calcuation if Field is Blank?!

fumei · #1 05-08-2013, 10:11 PM

Ooops! My bad. Yes docFF should refers to all the formfields in the document.

Code:

Dim docFF as FormFields ' declares docFF as the formfield collection
Set docFF = ActiveDocument.Formfields() ' sets the object

Sorry about that. I am surprised Paul did not call me on that. I am even more surprised I missed it! Doh.

If you do go the field calculation route you are strongly advised to to listen to Paul and check out his Word Field Maths Tutorial. It is a few years old, but is still relevant and is still the very best learning source out there.

macropod · #2 05-09-2013, 01:25 AM

Quote:

Originally Posted by fumei

Sorry about that. I am surprised Paul did not call me on that. I am even more surprised I missed it! Doh.

I didn't call you on that because I haven't been monitoring this thread closely. Given your level of competence, I'm not inclined to check your work. Of course, as you know from our discussion at VBAX, I too make mistakes sometimes ...

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