Excel list box displaying "True" and "False" as '-1' and '0'

[crowmagnus]

My list box on my userform is showing TRUE as -1 and FALSE as 0, does anyone know a way I can make it show the actual value of TRUE and FALSE?

Thanks!!

[MarvinP]

Hey CM,

I put a single quote in front of your "True" and made it 'True to try to convert it to text. The clicked the button and "magic" it showed as True instead of -1. I guess Excel thinks "True" is really "-1". Why???
Can you deal with putting a single quote in front of those "True"?

Hope this helps. Maybe somebody else will have a better answer.

Edit: If you use "Done" for True and "Not Yet" for False it shows the full word and means the same.

[crowmagnus]

That works, it just doesn't work with my conditional formatting. I could probably live with that. I've never ran into this problem before. I have another sheet where it works fine.

[crowmagnus]

You're right. I'll just use "complete" or something. Thanks!!

[nigelog]

With your code a workaround

Please Login or Register  to view this content.

[BMV]

I guess Excel thinks "True" is really "-1". Why???

Becaose TRUE it is Not False . False =0 - not 0 is FFFF because every bit is inverted. FFFF is -1

Try: Debug.Print Not 0, Hex(Not 0), True And 1

[crowmagnus]

Thanks for all the help!

[nigelog]

Did you try the code posted above?? Just curious if it works for you there as a bit Heath Robinson

[MarvinP]

Sometimes True = 1 and sometimes -1. That is why I gave my

[BMV]

MarvinP I have neve seen it in VBA but worksheet function it's so.

[MarvinP]

Here was an old discussion on True is 1 or -1.
https://www.excelforum.com/excel-gen...worksheet.html

[crowmagnus]

Did you try the code posted above?? Just curious if it works for you there as a bit Heath Robinson

It worked great. It's what I went with.

[jindon]

True =1 in a cell, -1 for vba.
Recognize as True other than 0(False) for both.

Please Login or Register  to view this content.