Validation code for macro to run

[[email protected]]

Hi...the code below works fine, but how do I change it so that it
doesn't look for a blank cell (""), but looks for specific text in a
cell? There is an If formula in cell C269 so that if 2 figures balance
then this cell displays "TRUE", otherwise it displays "FALSE".

The code mustn't run if Cell C269 displays "FALSE".

If [C269] = "" Then
MsgBox "The figures don't balance!!"
Exit Sub
End If
Range("E1:E48").Select
Selection.Copy
End Sub

Thanks.

Rob

[Paul B]

Rob, try this,

If [C269] = "False" Then
MsgBox "The figures don't balance!!"
Exit Sub
End If
Range("E1:E48").Select
Selection.Copy
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

<[email protected]> wrote in message
news:[email protected]...
> Hi...the code below works fine, but how do I change it so that it
> doesn't look for a blank cell (""), but looks for specific text in a
> cell? There is an If formula in cell C269 so that if 2 figures balance
> then this cell displays "TRUE", otherwise it displays "FALSE".
>
> The code mustn't run if Cell C269 displays "FALSE".
>
> If [C269] = "" Then
> MsgBox "The figures don't balance!!"
> Exit Sub
> End If
> Range("E1:E48").Select
> Selection.Copy
> End Sub
>
> Thanks.
>
> Rob
>