Reference a ToggleButton in Cell Formula

[zinzah]

I am trying to reference the status of a Toggle Button in a formul
within a cell. I am trying to have a cell recalculate based upo
whether the value of tglActCon1 is true or false. The button toggle
between “A” (False) and “C”(True), but I am getting the “# Name” erro
with this formula:

=IF(A11=0,"",IF(forms.tglActCon1.value=TRUE,"",VLOOKUP(A11,'GAM
INFO'!A1:E200,3)))

Or, I do not get an error, but it does not recalculate if I use thi
formula:

=IF(A11=0,"",IF(“forms.tglActCon1.value”=TRUE,"",VLOOKUP(A11,'GAM
INFO'!A1:E200,3)))



Hope this is enough info….

 

[Vasant Nanavati]

Can't be done, unless you link the state of the control to a cell and then
refer to the linked cell in your formula.

 

[zinzah]

Excellent!! Again, another question answered here!!! This place is th
best!! Thank you!!!

 

[Vasant Nanavati]

You're welcome; thanks for the feedback!