Comparison operator

P

Pawan

Hi...

My code is:

If Cells(rw, colno).Value = "US" Or _
Cells(rw, colno).Value = "AI" Then
With Cells(rw, colno)

If UserForm1.ch_sensrtype_d.Value = False Then
.Value = UserForm1.sensrtype.Value
Else
.Value = sensrtype_d
End If
ENd IF

In the line
Cells(rw, colno).Value = "AI", I am comapring cell value with "AI".
However, here I want to search if any part of the cell contains "AI". Measn,
if my cell has value "AIT", then also this statement should become true.

I tried writing "*" & "AI" & "*" but it doesnt work. How can I do this?

Regards,

Pawan
 
B

Bob Phillips

If Cells(rw, colno).Value = "US" Or _
Cells(rw, colno).Value Like "*AI*" Then


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
P

Pawan

Thanks Bob...

I have onem ore doubt in this. My macro is searching for "US" (i.e.
Uppercase). If there is "us" in some cells, its not working. Can we make it
work?

Regards,
Pawan
 
B

Bob Phillips

If LCase(Cells(rw, colno).Value) = "us" Or _
Cells(rw, colno).Value Like "*AI*" Then

this will work for us, US, Us, or uS, that is it is non case-sensitive.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
P

Pawan

Great.. Thanks Bob..! :)

Bob Phillips said:
If LCase(Cells(rw, colno).Value) = "us" Or _
Cells(rw, colno).Value Like "*AI*" Then

this will work for us, US, Us, or uS, that is it is non case-sensitive.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
Click to expand...
 
Top