Conditional test not evaluating properly

[Dr. Demento]

For the life of me, I cannot figure this out. When the cell at .Cells(i, col) has the value 0\1 (as text), my conditional statement that evaluates if str = "0/1" is FALSE. Likewise, str Like "0/*" is always FALSE for values like "0\9". What am I doing wrong?

' ~~ Format START/STOP cells for better visualization
          col = tbl_Watchstop.ListColumns("Split counter").DataBodyRange.column
          For i = 1 To tbl_Watchstop.ListRows.count + 1
            str = .Cells(i, col).value
            If str = "0/1" Then .Cells(i, col).Interior.Color = 6750156  ' ~~ Light green for START
            If str Like "0/*" And str <> "0/1" Then .Cells(i, col).Interior.Color = 16764159  ' ~~ Light pink for STOP
          Next i

 

[BarryL]

what does str give you in the immediate window

' ~~ Format START/STOP cells for better visualization
          col = tbl_Watchstop.ListColumns("Split counter").DataBodyRange.column
          For i = 1 To tbl_Watchstop.ListRows.count + 1
            str = .Cells(i, col).value
Debug.Print str
            If str = "0/1" Then .Cells(i, col).Interior.Color = 6750156  ' ~~ Light green for START
            If str Like "0/*" And str <> "0/1" Then .Cells(i, col).Interior.Color = 16764159  ' ~~ Light pink for STOP
          Next I

 

[Dr. Demento]

?str
0\1

 

[Dr. Demento]

Oh, and ValType(str) is 8 (string)

 

[Dr. Demento]

bump

 

[Tetra201]

For the life of me, I cannot figure this out. When the cell at .Cells(i, col) has the value 0\1 (as text), my conditional statement that evaluates if str = "0/1" is FALSE. Likewise, str Like "0/*" is always FALSE for values like "0\9". What am I doing wrong?

Comparing backslashes ("\") with forwardslashes ("/")?

 

[Dr. Demento]

You've got to be kidding me!! I knew it had to be something bone-headed, but I had no idea I was THAT bone-headed!!!

Pointing out errors without being judgemental -- that's a community worth being a part of. Thanks, Tetra.

 

[Tetra201]

You are welcome.