Check box

[Dhimit]

Hi,

Can somebody pls. tell me the syntax for using a checkbox in a col. ?

If checkbox checked >> Syntax ??
If un-checked >. Syntax ??

Does it simply evaluate to val. of cell to either 'Y' or 'N' ?

Pls. advise.

 

[Jonmo1]

Checkbox values are true false...
Checked = True
UnChecked = False

If CheckBox1 = TRUE Then
    Action if it's checked
Else
    Action if it's false
End If

Hope that helps..

 

[Dhimit]

Checkbox values are true false...
Checked = True
UnChecked = False

If CheckBox1 = TRUE Then
    Action if it's checked
Else
    Action if it's false
End If

Hope that helps..

Thnaks.

How do i incorporate this in a 'IF' function statement ?

I tried this but it only evaluates to 'n' , i.e it does'nt give a result to 'y' when unchecked

=IF(I3=TRUE,"yes","no" )


Rgds - DC

 

[Jonmo1]

If you want it to be Yes when it's UNchecked, and No when it IS Checked..

=IF(I3=TRUE,"No","Yes")

The checkbox value is FALSE when UNchecked, TRUE when CHECKED.

 

[Dhimit]

If you want it to be Yes when it's UNchecked, and No when it IS Checked..

=IF(I3=TRUE,"No","Yes")

The checkbox value is FALSE when UNchecked, TRUE when CHECKED.

Thanks - why is that when i toggle the checkbox it does'nt evaluate the result ?

it returns value on the 1st instance, but it does'nt return value of opp. action ?

 

[Jonmo1]

Do you have the "Linked Cell" Property of the Checkbox Set to I3 ?

Do you see the Text TRUE or FALSE in I3?

 

[Dhimit]

Do you have the "Linked Cell" Property of the Checkbox Set to I3 ? >> How do i do this ?

Do you see the Text TRUE or FALSE in I3?

I've placed the checkbox on I3 & evaluating result to another cell > K3

 

[Jonmo1]

Was the checkbox cretead with the "Forms" Toolbar or the "Control Toolbox" toolbar?

It would be better created by the Control Toolbox..

Then you can right click the checkbox, choose properties.
Theres a property called "Linked Cell", set that to I3

 

[Dhimit]

I've placed the checkbox on I3 & evaluating result to another cell > K3

thanks - i've figured it out !!

 

[Dhimit]

I used checkbox from Control toolbox, but can't seem to call up the properties when i right click ?

DC