What Data Type do you use for Boolean plus one. True, False and TBD

[USAMax]

I have a complicated routine that I am writing that would normally be Boolean but there are a few times when the answer will be To Be Determined. There are some that are clearly defined with a lot of IF THEN ELSE statements but when all is said and done, there will be three answers.

There are a lot of ways to handle this and I would like to use a IF ROUTINE(VARIABLES) THEN statement in my code but with the third option I cannot.

I am not asking how to write the code, I want to know you found it best to return the answer.

What it the way you found to handle this True, False, Maybe problem?

 

[shg]

You could use the VbTriState constants (vbTrue, vbFalse, vbUseDefault)

 

[Kyle123]

Or create an enum for true, false and to be determined. N.B This is the same as shg's suggestion, but is a little more flexible since it would allow you to add additional statuses if required

 

[shg]

I like Kyle's suggestion better.

You could do the whole Magic Eight Ball enumeration of answers.