String Compares

[bstubbs]

My program assigns a variable one of three values - either "Lancaster", "DeSoto" or "Cedar Hill". My string compares for Lancaster and DeSoto work fine but can't get anything happening for Cedar Hill. I looked at the value of the variable and it appears to be correct. However, when I did a StrComp for the variable and the string "Cedar Hill", they did, of course, not come out as equal. What am I missing?

[davesexcel]

Try supplying the code........

[Leith Ross]

Hello bstubbs,

As Dave mentioned, seeing your workbook would help. Here are a few common problems to look for. Sometimes leading or trailing spaces can cause this, especially if the text was entered by the user. Use the Trim function to remove any leading or trailing spaces. Case can be another problem. It is always best to use case insensitive comparisons. Check the if the macro module is explicitly setting the type of comparison with the Option Compare statement, as this will override any code settings.

Sincerely,
Leith Ross

[bstubbs]

I didn't think that it was a leading or trailing space issue in that it didn't happen with two of the selections, only the third. However, I changed the code to "isdName = lTrim(rTrim(active.cell.value))" and it worked fine. Go figure. Anyway, if you hadn't mentioned that, I wouldn't have checked. I feel stupid but appreciate the input.