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 ...

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 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