Answer a function with a string

[chrismccarthy17]

Just out of interest, why does this not work? Is there a way for it to work?

Please Login or Register  to view this content.

[Andy Pope]

try

Please Login or Register  to view this content.

This assumes answer either contains TRUE or FALSE

[chrismccarthy17]

try

Please Login or Register  to view this content.

This assumes answer either contains TRUE or FALSE

Thank you! This is going to help me with something much bigger, just this as a basic example.

[mikerickson]

CBool("cat") returns a type mismatch error.
A test that would never error would be

Please Login or Register  to view this content.

or, since a Worksheet's Visible property isn't Boolean,

Please Login or Register  to view this content.