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

how would i unclick the option button without having to click the other. i
would need to have none of the buttons selected. If i selected buton 2 in
error but don't want button 1 selected how do i remove button 2 selection?

"Bob Phillips" wrote:

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

Now that is a reason for using checkboxes, you can't do it <G

To get back to the original question, you can set a cell like so

Range("C1").value = Not Range("C2 ").Value

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"DanDavis" wrote in message
...
how would i unclick the option button without having to click the other.
i
would need to have none of the buttons selected. If i selected buton 2
in
error but don't want button 1 selected how do i remove button 2 selection?

"Bob Phillips" wrote:

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

thanks. now what i need to do is this:

if cell c1 has a value then checkbox1.value = true else checkbox1.value =
false

"Bob Phillips" wrote:

Now that is a reason for using checkboxes, you can't do it <G

To get back to the original question, you can set a cell like so

Range("C1").value = Not Range("C2 ").Value

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"DanDavis" wrote in message
...
how would i unclick the option button without having to click the other.
i
would need to have none of the buttons selected. If i selected buton 2
in
error but don't want button 1 selected how do i remove button 2 selection?

"Bob Phillips" wrote:

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

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

CheckBox1 = Range("C1") < ""

End Sub


"DanDavis" wrote:

thanks. now what i need to do is this:

if cell c1 has a value then checkbox1.value = true else checkbox1.value =
false

"Bob Phillips" wrote:

Now that is a reason for using checkboxes, you can't do it <G

To get back to the original question, you can set a cell like so

Range("C1").value = Not Range("C2 ").Value

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"DanDavis" wrote in message
...
how would i unclick the option button without having to click the other.
i
would need to have none of the buttons selected. If i selected buton 2
in
error but don't want button 1 selected how do i remove button 2 selection?

"Bob Phillips" wrote:

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