Convert a String Name to Declared Boolean

**bdb1974** · 05-16-2012, 12:00 PM

Hi all,

I'm wondering how if possible to convert a string to a Boolean
For instance, normally someone would use:

Please Login or Register  to view this content.

However, I'd like to say something like the following.

Please Login or Register  to view this content.

Any Help is welcome.

Thanks,

BDB

**Mordred** · 05-16-2012, 12:04 PM

I'm not sure but maybe

Please Login or Register  to view this content.

**InvisibleMan** · 05-16-2012, 12:13 PM

Please Login or Register  to view this content.

Note that Choose is a reserved word (an Excel function) so I've added "s" for string.

As z was not defined, I have defined it. It isn't set so, by default, it will be zero and, hence, not equal to 1 (one) and the value of sChoose won't change.

TIM

**InvisibleMan** · 05-16-2012, 12:14 PM

Probably should have asked, why do you want a string variable to represent the value?

**JosephP** · 05-16-2012, 12:56 PM

if you want to use a string as the variable name, then no you can't. you could create a class with some properties (booleans) and then use your string to refer to those properties by name but I can't think of a reason why you would ;-)

**bdb1974** · 05-16-2012, 03:34 PM

Thanks for both of your replies. The solutions provided are not quite what I was hoping to get.
I don't think I phrased my question quite right to describe what actually I'm trying to do.
Please let me try to reword my problem.

"Check,Check2 and Check3 are already Publicly dimmed as Booleans" for the following:

Please Login or Register  to view this content.

I guess maybe MyBoolean could be a Function

**bdb1974** · 05-16-2012, 03:36 PM

Here's something I've come up with but still not what I'm wanting. I think I'm wanting to treat the Boolean as an object.

Please Login or Register  to view this content.

I'd like to shorten this if possible.
Maybe the following is all I can do?

Please Login or Register  to view this content.

I'd like to shorten even further so as to avoid stating " if Z = then"
z=1
I'd like to just say: uck = True ' where uck is check

**InvisibleMan** · 05-16-2012, 03:51 PM

To be honest, I think you're going about it back to front. You have three boolean variables which may be true or false and one string variable that you want to reflect the boolean variable(s). so why not:

Please Login or Register  to view this content.

TIM

**JosephP** · 05-16-2012, 04:35 PM

Please Login or Register  to view this content.

**bdb1974** · 05-16-2012, 05:41 PM

TIM,
Actually, what I'm trying to do I believe is impossible. I would like to set UCK to one of the 3 checks, like you can with objects. But,since the checks are Boolean, I can't. I guess, if I were to treat my CHECKs as strings, than I could say UCK = "CHECK=TRUE"/"CHECK2=TRUE"/"CHECK3=TRUE" Today I've run out of time, I'll look at this again tomorrow.

Thanks,
BDB