calculate on exit/macro exit

B

bryan

Do these 2 not work together?
I have a table with formfields which I use to calculate sub-total, subtract,
and then a grand total. On all of the formfields I have a 'calc on exit' . I
also had an exit macro on one formfield to hide/unhide some text below the
table depending upon the value entered.
IE:
Total Value <text1>
Title/Tab fees <text2>
Tax <text3>
Subtotal <formula, =sum(above)>
Minud Ded <text5>
Minus Holdback <text6>
Less Salvage <text7>
Total <formula,
(text1)+(text2)+(text3)-(text5)-(text6)-(text7)>

This works fine until I put an exit macro on <text5> which runs to hide text
below this table. The exit macro will run but, the "Total" will not change.
I have a work around by including a <text> formfield below this to run the
hide/unhide dependant upon <text6> value but, that seems a bit hockie!

Any ideas or suggestions.

Thanks,
Bryan
 
M

macropod

Hi Bryan,

Instead of using an 'on exit' macro, you could use an ordinary IF field to test the contents of Text5 and display/hide the dependant
text accordingly. Then all Text5 needs is for the 'calculate on exit' property to be checked. Coding for the IF field could be
something like:
{IF{Text3}= 0 "Text if 0" "Text if not 0"}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.
 
B

bryan

How do I get this code in the if statement?
This is the macro that runs on the exit:
Can the if statement call this macro?

Thanks,
Bryan

Sub NHB()
'
' NHB Macro
' Macro created 1/29/2009 by bjsorens
'
'No Holdback
If ActiveDocument.FormFields("text5").Result = "" Or
ActiveDocument.FormFields("text5").Result = "$0.00" Then
'With ActiveDocument
' ActiveDocument.Unprotect
' .Range(.Tables(1).Rows(5).Range.Start,
..Tables(1).Rows(5).Range.End).Rows.Delete
' ActiveDocument.Protect wdAllowOnlyFormFields, NoReset
'End With
With ActiveDocument
ActiveDocument.Unprotect
.FormFields("Text10").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text11").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text12").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text13").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text14").Range.Paragraphs(1).Range.Font.Hidden = True
ActiveWindow.View.ShowHiddenText = True
ActiveDocument.Protect wdAllowOnlyFormFields, NoReset
End With
Else
With ActiveDocument
ActiveDocument.Unprotect
.FormFields("Text10").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text11").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text12").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text13").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text14").Range.Paragraphs(1).Range.Font.Hidden = False
ActiveWindow.View.ShowHiddenText = True
ActiveDocument.Protect wdAllowOnlyFormFields, NoReset
End With
End If
End Sub


macropod said:
Hi Bryan,

Instead of using an 'on exit' macro, you could use an ordinary IF field to test the contents of Text5 and display/hide the dependant
text accordingly. Then all Text5 needs is for the 'calculate on exit' property to be checked. Coding for the IF field could be
something like:
{IF{Text3}= 0 "Text if 0" "Text if not 0"}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]


bryan said:
Do these 2 not work together?
I have a table with formfields which I use to calculate sub-total, subtract,
and then a grand total. On all of the formfields I have a 'calc on exit' . I
also had an exit macro on one formfield to hide/unhide some text below the
table depending upon the value entered.
IE:
Total Value <text1>
Title/Tab fees <text2>
Tax <text3>
Subtotal <formula, =sum(above)>
Minud Ded <text5>
Minus Holdback <text6>
Less Salvage <text7>
Total <formula,
(text1)+(text2)+(text3)-(text5)-(text6)-(text7)>

This works fine until I put an exit macro on <text5> which runs to hide text
below this table. The exit macro will run but, the "Total" will not change.
I have a work around by including a <text> formfield below this to run the
hide/unhide dependant upon <text6> value but, that seems a bit hockie!

Any ideas or suggestions.

Thanks,
Bryan
Click to expand...
Click to expand...
 
M

macropod

Hi Bryan,

In your original post you said "I also had an exit macro on one formfield to hide/unhide some text below the table depending upon
the value entered." What it seems you actually have is a range of formfields whose contents you want to display/hide by changing the
font attributes. That's a rather different proposition to just showing/hiding text, and can't be done with field coding.

FWIW, a quick read of your macro suggests it could be reduced to:
Sub NHB()
'No Holdback
Dim Toggle As Boolean
Toggle = False
With ActiveDocument
.Unprotect
If Trim(.FormFields("text5").Result) = "" Or .FormFields("text5").Result = "$0.00" Then
.Tables(1).Rows(5).Delete
Toggle = True
End If
.FormFields("Text10").Range.Paragraphs(1).Range.Font.Hidden = Toggle
.FormFields("Text11").Range.Paragraphs(1).Range.Font.Hidden = Toggle
.FormFields("Text12").Range.Paragraphs(1).Range.Font.Hidden = Toggle
.FormFields("Text13").Range.Paragraphs(1).Range.Font.Hidden = Toggle
.FormFields("Text14").Range.Paragraphs(1).Range.Font.Hidden = Toggle
ActiveWindow.View.ShowHiddenText = Not Toggle
.Protect wdAllowOnlyFormFields, NoReset
End With
End Sub


--
Cheers
macropod
[MVP - Microsoft Word]


bryan said:
How do I get this code in the if statement?
This is the macro that runs on the exit:
Can the if statement call this macro?

Thanks,
Bryan

Sub NHB()
'
' NHB Macro
' Macro created 1/29/2009 by bjsorens
'
'No Holdback
If ActiveDocument.FormFields("text5").Result = "" Or
ActiveDocument.FormFields("text5").Result = "$0.00" Then
'With ActiveDocument
' ActiveDocument.Unprotect
' .Range(.Tables(1).Rows(5).Range.Start,
.Tables(1).Rows(5).Range.End).Rows.Delete
' ActiveDocument.Protect wdAllowOnlyFormFields, NoReset
'End With
With ActiveDocument
ActiveDocument.Unprotect
.FormFields("Text10").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text11").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text12").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text13").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text14").Range.Paragraphs(1).Range.Font.Hidden = True
ActiveWindow.View.ShowHiddenText = True
ActiveDocument.Protect wdAllowOnlyFormFields, NoReset
End With
Else
With ActiveDocument
ActiveDocument.Unprotect
.FormFields("Text10").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text11").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text12").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text13").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text14").Range.Paragraphs(1).Range.Font.Hidden = False
ActiveWindow.View.ShowHiddenText = True
ActiveDocument.Protect wdAllowOnlyFormFields, NoReset
End With
End If
End Sub


macropod said:
Hi Bryan,

Instead of using an 'on exit' macro, you could use an ordinary IF field to test the contents of Text5 and display/hide the
dependant
text accordingly. Then all Text5 needs is for the 'calculate on exit' property to be checked. Coding for the IF field could be
something like:
{IF{Text3}= 0 "Text if 0" "Text if not 0"}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]


bryan said:
Do these 2 not work together?
I have a table with formfields which I use to calculate sub-total, subtract,
and then a grand total. On all of the formfields I have a 'calc on exit' . I
also had an exit macro on one formfield to hide/unhide some text below the
table depending upon the value entered.
IE:
Total Value <text1>
Title/Tab fees <text2>
Tax <text3>
Subtotal <formula, =sum(above)>
Minud Ded <text5>
Minus Holdback <text6>
Less Salvage <text7>
Total <formula,
(text1)+(text2)+(text3)-(text5)-(text6)-(text7)>

This works fine until I put an exit macro on <text5> which runs to hide text
below this table. The exit macro will run but, the "Total" will not change.
I have a work around by including a <text> formfield below this to run the
hide/unhide dependant upon <text6> value but, that seems a bit hockie!

Any ideas or suggestions.

Thanks,
Bryan
Click to expand...
Click to expand...
Click to expand...
 
B

bryan

Thanks macropod.
I tried to be as clear as posible in my original post.
Question is then.
Why does calculate on exit and macro exit not work together?
If I have 'calc on exit checked' and NHB macro on exit to run, the macro
will run and hide or unhide the text but, the total is not calculated.....

A work-around was to have an extra field to be tabbed out of to call the
macro.
Default value "Exit here to hide/unhide hodlback"

Thanks,
Bryan


Any better ideas?

macropod said:
Hi Bryan,

In your original post you said "I also had an exit macro on one formfield to hide/unhide some text below the table depending upon
the value entered." What it seems you actually have is a range of formfields whose contents you want to display/hide by changing the
font attributes. That's a rather different proposition to just showing/hiding text, and can't be done with field coding.

FWIW, a quick read of your macro suggests it could be reduced to:
Sub NHB()
'No Holdback
Dim Toggle As Boolean
Toggle = False
With ActiveDocument
.Unprotect
If Trim(.FormFields("text5").Result) = "" Or .FormFields("text5").Result = "$0.00" Then
.Tables(1).Rows(5).Delete
Toggle = True
End If
.FormFields("Text10").Range.Paragraphs(1).Range.Font.Hidden = Toggle
.FormFields("Text11").Range.Paragraphs(1).Range.Font.Hidden = Toggle
.FormFields("Text12").Range.Paragraphs(1).Range.Font.Hidden = Toggle
.FormFields("Text13").Range.Paragraphs(1).Range.Font.Hidden = Toggle
.FormFields("Text14").Range.Paragraphs(1).Range.Font.Hidden = Toggle
ActiveWindow.View.ShowHiddenText = Not Toggle
.Protect wdAllowOnlyFormFields, NoReset
End With
End Sub


--
Cheers
macropod
[MVP - Microsoft Word]


bryan said:
How do I get this code in the if statement?
This is the macro that runs on the exit:
Can the if statement call this macro?

Thanks,
Bryan

Sub NHB()
'
' NHB Macro
' Macro created 1/29/2009 by bjsorens
'
'No Holdback
If ActiveDocument.FormFields("text5").Result = "" Or
ActiveDocument.FormFields("text5").Result = "$0.00" Then
'With ActiveDocument
' ActiveDocument.Unprotect
' .Range(.Tables(1).Rows(5).Range.Start,
.Tables(1).Rows(5).Range.End).Rows.Delete
' ActiveDocument.Protect wdAllowOnlyFormFields, NoReset
'End With
With ActiveDocument
ActiveDocument.Unprotect
.FormFields("Text10").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text11").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text12").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text13").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text14").Range.Paragraphs(1).Range.Font.Hidden = True
ActiveWindow.View.ShowHiddenText = True
ActiveDocument.Protect wdAllowOnlyFormFields, NoReset
End With
Else
With ActiveDocument
ActiveDocument.Unprotect
.FormFields("Text10").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text11").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text12").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text13").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text14").Range.Paragraphs(1).Range.Font.Hidden = False
ActiveWindow.View.ShowHiddenText = True
ActiveDocument.Protect wdAllowOnlyFormFields, NoReset
End With
End If
End Sub


macropod said:
Hi Bryan,

Instead of using an 'on exit' macro, you could use an ordinary IF field to test the contents of Text5 and display/hide the
dependant
text accordingly. Then all Text5 needs is for the 'calculate on exit' property to be checked. Coding for the IF field could be
something like:
{IF{Text3}= 0 "Text if 0" "Text if not 0"}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]


Do these 2 not work together?
I have a table with formfields which I use to calculate sub-total, subtract,
and then a grand total. On all of the formfields I have a 'calc on exit' . I
also had an exit macro on one formfield to hide/unhide some text below the
table depending upon the value entered.
IE:
Total Value <text1>
Title/Tab fees <text2>
Tax <text3>
Subtotal <formula, =sum(above)>
Minud Ded <text5>
Minus Holdback <text6>
Less Salvage <text7>
Total <formula,
(text1)+(text2)+(text3)-(text5)-(text6)-(text7)>

This works fine until I put an exit macro on <text5> which runs to hide text
below this table. The exit macro will run but, the "Total" will not change.
I have a work around by including a <text> formfield below this to run the
hide/unhide dependant upon <text6> value but, that seems a bit hockie!

Any ideas or suggestions.

Thanks,
Bryan
Click to expand...
Click to expand...
Click to expand...
 
M

macropod

Hi Bryan,

I can't see any good reason for an 'on exit' macro and 'calculate on exit' not to happily co-exist. Nevertheless, you could modify
your 'on exit' macro to force the relevant fields to update.

--
Cheers
macropod
[MVP - Microsoft Word]


bryan said:
Thanks macropod.
I tried to be as clear as posible in my original post.
Question is then.
Why does calculate on exit and macro exit not work together?
If I have 'calc on exit checked' and NHB macro on exit to run, the macro
will run and hide or unhide the text but, the total is not calculated.....

A work-around was to have an extra field to be tabbed out of to call the
macro.
Default value "Exit here to hide/unhide hodlback"

Thanks,
Bryan


Any better ideas?

macropod said:
Hi Bryan,

In your original post you said "I also had an exit macro on one formfield to hide/unhide some text below the table depending upon
the value entered." What it seems you actually have is a range of formfields whose contents you want to display/hide by changing
the
font attributes. That's a rather different proposition to just showing/hiding text, and can't be done with field coding.

FWIW, a quick read of your macro suggests it could be reduced to:
Sub NHB()
'No Holdback
Dim Toggle As Boolean
Toggle = False
With ActiveDocument
.Unprotect
If Trim(.FormFields("text5").Result) = "" Or .FormFields("text5").Result = "$0.00" Then
.Tables(1).Rows(5).Delete
Toggle = True
End If
.FormFields("Text10").Range.Paragraphs(1).Range.Font.Hidden = Toggle
.FormFields("Text11").Range.Paragraphs(1).Range.Font.Hidden = Toggle
.FormFields("Text12").Range.Paragraphs(1).Range.Font.Hidden = Toggle
.FormFields("Text13").Range.Paragraphs(1).Range.Font.Hidden = Toggle
.FormFields("Text14").Range.Paragraphs(1).Range.Font.Hidden = Toggle
ActiveWindow.View.ShowHiddenText = Not Toggle
.Protect wdAllowOnlyFormFields, NoReset
End With
End Sub


--
Cheers
macropod
[MVP - Microsoft Word]


bryan said:
How do I get this code in the if statement?
This is the macro that runs on the exit:
Can the if statement call this macro?

Thanks,
Bryan

Sub NHB()
'
' NHB Macro
' Macro created 1/29/2009 by bjsorens
'
'No Holdback
If ActiveDocument.FormFields("text5").Result = "" Or
ActiveDocument.FormFields("text5").Result = "$0.00" Then
'With ActiveDocument
' ActiveDocument.Unprotect
' .Range(.Tables(1).Rows(5).Range.Start,
.Tables(1).Rows(5).Range.End).Rows.Delete
' ActiveDocument.Protect wdAllowOnlyFormFields, NoReset
'End With
With ActiveDocument
ActiveDocument.Unprotect
.FormFields("Text10").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text11").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text12").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text13").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text14").Range.Paragraphs(1).Range.Font.Hidden = True
ActiveWindow.View.ShowHiddenText = True
ActiveDocument.Protect wdAllowOnlyFormFields, NoReset
End With
Else
With ActiveDocument
ActiveDocument.Unprotect
.FormFields("Text10").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text11").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text12").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text13").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text14").Range.Paragraphs(1).Range.Font.Hidden = False
ActiveWindow.View.ShowHiddenText = True
ActiveDocument.Protect wdAllowOnlyFormFields, NoReset
End With
End If
End Sub


:

Hi Bryan,

Instead of using an 'on exit' macro, you could use an ordinary IF field to test the contents of Text5 and display/hide the
dependant
text accordingly. Then all Text5 needs is for the 'calculate on exit' property to be checked. Coding for the IF field could be
something like:
{IF{Text3}= 0 "Text if 0" "Text if not 0"}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy &
paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]


Do these 2 not work together?
I have a table with formfields which I use to calculate sub-total, subtract,
and then a grand total. On all of the formfields I have a 'calc on exit' . I
also had an exit macro on one formfield to hide/unhide some text below the
table depending upon the value entered.
IE:
Total Value <text1>
Title/Tab fees <text2>
Tax <text3>
Subtotal <formula, =sum(above)>
Minud Ded <text5>
Minus Holdback <text6>
Less Salvage <text7>
Total <formula,
(text1)+(text2)+(text3)-(text5)-(text6)-(text7)>

This works fine until I put an exit macro on <text5> which runs to hide text
below this table. The exit macro will run but, the "Total" will not change.
I have a work around by including a <text> formfield below this to run the
hide/unhide dependant upon <text6> value but, that seems a bit hockie!

Any ideas or suggestions.

Thanks,
Bryan
Click to expand...
Click to expand...
Click to expand...
 
B

bryan

I am running the macro on 'calc on entry' field on <text6> field and this
works fine. Not sure why they don't happily get along on exit.

Thanks,
Bryan

macropod said:
Hi Bryan,

I can't see any good reason for an 'on exit' macro and 'calculate on exit' not to happily co-exist. Nevertheless, you could modify
your 'on exit' macro to force the relevant fields to update.

--
Cheers
macropod
[MVP - Microsoft Word]


bryan said:
Thanks macropod.
I tried to be as clear as posible in my original post.
Question is then.
Why does calculate on exit and macro exit not work together?
If I have 'calc on exit checked' and NHB macro on exit to run, the macro
will run and hide or unhide the text but, the total is not calculated.....

A work-around was to have an extra field to be tabbed out of to call the
macro.
Default value "Exit here to hide/unhide hodlback"

Thanks,
Bryan


Any better ideas?

macropod said:
Hi Bryan,

In your original post you said "I also had an exit macro on one formfield to hide/unhide some text below the table depending upon
the value entered." What it seems you actually have is a range of formfields whose contents you want to display/hide by changing
the
font attributes. That's a rather different proposition to just showing/hiding text, and can't be done with field coding.

FWIW, a quick read of your macro suggests it could be reduced to:
Sub NHB()
'No Holdback
Dim Toggle As Boolean
Toggle = False
With ActiveDocument
.Unprotect
If Trim(.FormFields("text5").Result) = "" Or .FormFields("text5").Result = "$0.00" Then
.Tables(1).Rows(5).Delete
Toggle = True
End If
.FormFields("Text10").Range.Paragraphs(1).Range.Font.Hidden = Toggle
.FormFields("Text11").Range.Paragraphs(1).Range.Font.Hidden = Toggle
.FormFields("Text12").Range.Paragraphs(1).Range.Font.Hidden = Toggle
.FormFields("Text13").Range.Paragraphs(1).Range.Font.Hidden = Toggle
.FormFields("Text14").Range.Paragraphs(1).Range.Font.Hidden = Toggle
ActiveWindow.View.ShowHiddenText = Not Toggle
.Protect wdAllowOnlyFormFields, NoReset
End With
End Sub


--
Cheers
macropod
[MVP - Microsoft Word]


How do I get this code in the if statement?
This is the macro that runs on the exit:
Can the if statement call this macro?

Thanks,
Bryan

Sub NHB()
'
' NHB Macro
' Macro created 1/29/2009 by bjsorens
'
'No Holdback
If ActiveDocument.FormFields("text5").Result = "" Or
ActiveDocument.FormFields("text5").Result = "$0.00" Then
'With ActiveDocument
' ActiveDocument.Unprotect
' .Range(.Tables(1).Rows(5).Range.Start,
.Tables(1).Rows(5).Range.End).Rows.Delete
' ActiveDocument.Protect wdAllowOnlyFormFields, NoReset
'End With
With ActiveDocument
ActiveDocument.Unprotect
.FormFields("Text10").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text11").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text12").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text13").Range.Paragraphs(1).Range.Font.Hidden = True
.FormFields("Text14").Range.Paragraphs(1).Range.Font.Hidden = True
ActiveWindow.View.ShowHiddenText = True
ActiveDocument.Protect wdAllowOnlyFormFields, NoReset
End With
Else
With ActiveDocument
ActiveDocument.Unprotect
.FormFields("Text10").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text11").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text12").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text13").Range.Paragraphs(1).Range.Font.Hidden = False
.FormFields("Text14").Range.Paragraphs(1).Range.Font.Hidden = False
ActiveWindow.View.ShowHiddenText = True
ActiveDocument.Protect wdAllowOnlyFormFields, NoReset
End With
End If
End Sub


:

Hi Bryan,

Instead of using an 'on exit' macro, you could use an ordinary IF field to test the contents of Text5 and display/hide the
dependant
text accordingly. Then all Text5 needs is for the 'calculate on exit' property to be checked. Coding for the IF field could be
something like:
{IF{Text3}= 0 "Text if 0" "Text if not 0"}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy &
paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]


Do these 2 not work together?
I have a table with formfields which I use to calculate sub-total, subtract,
and then a grand total. On all of the formfields I have a 'calc on exit' . I
also had an exit macro on one formfield to hide/unhide some text below the
table depending upon the value entered.
IE:
Total Value <text1>
Title/Tab fees <text2>
Tax <text3>
Subtotal <formula, =sum(above)>
Minud Ded <text5>
Minus Holdback <text6>
Less Salvage <text7>
Total <formula,
(text1)+(text2)+(text3)-(text5)-(text6)-(text7)>

This works fine until I put an exit macro on <text5> which runs to hide text
below this table. The exit macro will run but, the "Total" will not change.
I have a work around by including a <text> formfield below this to run the
hide/unhide dependant upon <text6> value but, that seems a bit hockie!

Any ideas or suggestions.

Thanks,
Bryan
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automate bookmark naming of formfields 3
Need a formula to 14
Break table up into multiple tables by row count? 2
IF Function with multiple text entries 6
Vlookup based on a unique "Text" occur 0
Need help on formula. 3
Problem running macro from QAT 3
ListBox problem 2

Top