hello all,

i need to know how to program the value of a cell. meaning based on the
value of a cell i want another cell to do somthing.

Example: if the value of cell c2 = "yes" then c3 equals "5"

Thanks

Simply type in the cell C3 :
=if(C2="yes",5,10)
HTH
Carim

i need to do this programatically, the whole story is this, i have 2
checkboxes on the same row. when i check the 1st box i have some conditional
formating that happens. but when i check the 2nd box, i have the orginal cf
removed and a new cf put into place. i do this by playing with the value of
the 1st checkbox when the 2nd checkbox is clicked. my problem is if i only
click the 2nd check box and then uncheck it, the 1st cf is enacted becasue
the 1st checkbox value changes from false to true. i need to a check put
into place when i unclick the 2nd checkbox to see if the value of the 1st
checkbox should or should not be true. the check would be if cell D2
contains information then the value of the 1st checkbox should be true
otherwise it should be false.

example if value of cell d2 is true then checkbox1.value = true else
checkbox1.value = false

"Carim" wrote:

Simply type in the cell C3 :
=if(C2="yes",5,10)
HTH
Carim

Why not use optionbuttons? When you click one the other toggles as well.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"DanDavis" wrote in message
...
i need to do this programatically, the whole story is this, i have 2
checkboxes on the same row. when i check the 1st box i have some
conditional
formating that happens. but when i check the 2nd box, i have the orginal
cf
removed and a new cf put into place. i do this by playing with the value
of
the 1st checkbox when the 2nd checkbox is clicked. my problem is if i
only
click the 2nd check box and then uncheck it, the 1st cf is enacted becasue
the 1st checkbox value changes from false to true. i need to a check put
into place when i unclick the 2nd checkbox to see if the value of the 1st
checkbox should or should not be true. the check would be if cell D2
contains information then the value of the 1st checkbox should be true
otherwise it should be false.

example if value of cell d2 is true then checkbox1.value = true else
checkbox1.value = false

"Carim" wrote:

Simply type in the cell C3 :
=if(C2="yes",5,10)
HTH
Carim

i have 250 rows of info and each row has 2 checkboxes. i can't use option
buttons.

i need to know how to refer to a cell in vb

"Bob Phillips" wrote:

Why not use optionbuttons? When you click one the other toggles as well.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"DanDavis" wrote in message
...
i need to do this programatically, the whole story is this, i have 2
checkboxes on the same row. when i check the 1st box i have some
conditional
formating that happens. but when i check the 2nd box, i have the orginal
cf
removed and a new cf put into place. i do this by playing with the value
of
the 1st checkbox when the 2nd checkbox is clicked. my problem is if i
only
click the 2nd check box and then uncheck it, the 1st cf is enacted becasue
the 1st checkbox value changes from false to true. i need to a check put
into place when i unclick the 2nd checkbox to see if the value of the 1st
checkbox should or should not be true. the check would be if cell D2
contains information then the value of the 1st checkbox should be true
otherwise it should be false.

example if value of cell d2 is true then checkbox1.value = true else
checkbox1.value = false

"Carim" wrote:

Simply type in the cell C3 :
=if(C2="yes",5,10)
HTH
Carim

You can, you can group them

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"DanDavis" wrote in message
...
i have 250 rows of info and each row has 2 checkboxes. i can't use option
buttons.

i need to know how to refer to a cell in vb

"Bob Phillips" wrote:

Why not use optionbuttons? When you click one the other toggles as well.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"DanDavis" wrote in message
...
i need to do this programatically, the whole story is this, i have 2
checkboxes on the same row. when i check the 1st box i have some
conditional
formating that happens. but when i check the 2nd box, i have the
orginal
cf
removed and a new cf put into place. i do this by playing with the
value
of
the 1st checkbox when the 2nd checkbox is clicked. my problem is if i
only
click the 2nd check box and then uncheck it, the 1st cf is enacted
becasue
the 1st checkbox value changes from false to true. i need to a check
put
into place when i unclick the 2nd checkbox to see if the value of the
1st
checkbox should or should not be true. the check would be if cell D2
contains information then the value of the 1st checkbox should be true
otherwise it should be false.

example if value of cell d2 is true then checkbox1.value = true else
checkbox1.value = false

"Carim" wrote:

Simply type in the cell C3 :
=if(C2="yes",5,10)
HTH
Carim