Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Sean N. Sean N. is offline
external usenet poster
 
Posts: 1
Default Referencing a check box result within a formula

I am trying to create an "If" formula that uses a check box result as the
operator. What should I reference to get a desired result when a check box
is marked as opposed to unmarked?
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Referencing a check box result within a formula

Hi Sean,

Not possible via field coding, unfortunately, so you'll need to use a macro. For example, with a formfield checkbox named 'Check1'
you could set the following as an 'on exit' macro for that field:

Sub CheckState()
If ActiveDocument.FormFields("Check1").Result = 1 Then
'Whatever you want to do if the value = TRUE
End If
End Sub

--
Cheers
macropod
[MVP - Microsoft Word]


"Sean N." Sean wrote in message ...
I am trying to create an "If" formula that uses a check box result as the
operator. What should I reference to get a desired result when a check box
is marked as opposed to unmarked?


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get Formula result to update automatically? Mercedes.K Microsoft Word Help 3 April 21st 23 02:13 PM
Formula field syntax for testing check box Dave[_11_] Microsoft Word Help 1 June 4th 08 11:55 AM
Form Formula doesn't work if the result is ZERO? Angyl Microsoft Word Help 6 May 5th 06 03:33 PM
referencing cell with check box EstherH Tables 4 August 30th 05 04:16 AM
How do you create a formula in a table where the result appears a. papa did Tables 1 March 11th 05 10:49 PM


All times are GMT +1. The time now is 10:52 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"