If A1 = "TRUE", Then copy the value of A2 to A3

[jase71ds]

Hi.
Just as the title says, I need to copy the value of A2 into A3, but only if A1 = "TRUE".
Thanks for any help.

 

[ranman256]

formula for A3:
=if(A1="True",A2)

 

[jase71ds]

formula for A3:
=if(A1="True",A2)

I can't use formula. Here's the long version of what I need...
If the user selects a check box, then "TRUE" is put in cell J32. This part is done.
If the user deselects a check box, then "FALSE" is put in cell J32. This part is done.
I need to assign a macro to the check box, so that whenever the checkbox is toggled by the user, the macro will go and look to see whether the box is checked (TRUE) or unchecked (FALSE). If J32 = TRUE, then I need the values from G13:G14 pasted into G35:36.

So, that's the long answer. I was trying to keep the code simple initially because if someone can give me a solution for pasting the value of A2 into A3 if A1 = TRUE, then I can modify accordingly.

 

[Special-K99]

Cant you just put formulas in G35:G36
=IF(J32=TRUE,G13,"")
copy the formula to G36

 

[jase71ds]

Cant you just put formulas in G35:G36
=IF(J32=TRUE,G13,"")
copy the formula to G36

Good question, but: No, I can't use a formula. It's complicated to explain, but there are times the user is putting values into G35:G36, and they would, of course, overwrite any forumla.

 

[jase71ds]

Okay,
I figured out what was causing my problems. The macro is simple, but the problem is that my check boxes were generating "TRUE" or "FALSE" and I was trying to get the macro to look at these values and behave accordingly. What I discovered is that "TRUE" and "FALSE" (at least when generated by check boxes) are not text -- and even if you format for text, they are not text. So instead of this:

If Range("K35").Value = FALSE Then
or this...
If Range("K35").Value = "FALSE" Then

I needed to use this...

If Range("K35").Value = 0 Then

 

[Arithos]

Okay,
I figured out what was causing my problems. The macro is simple, but the problem is that my check boxes were generating "TRUE" or "FALSE" and I was trying to get the macro to look at these values and behave accordingly. What I discovered is that "TRUE" and "FALSE" (at least when generated by check boxes) are not text -- and even if you format for text, they are not text. So instead of this:

If Range("K35").Value = FALSE Then
or this...
If Range("K35").Value = "FALSE" Then

I needed to use this...

If Range("K35").Value = 0 Then

If you are using a macro you should post it initially, that will give you the best help. Would have solved it faster for you, however, glad its sorted

 

[jase71ds]

If you are using a macro you should post it initially, that will give you the best help. Would have solved it faster for you, however, glad its sorted

Agreed. Sorry for the pains. I was still thrashing through the macro at the time. I'm really slow (but determined). This board has been a huge help to me, and I'm very grateful.