VBA If variable contains...

[yoko]

Hi,

How could I get a program to react if a variable contained something.

Eg.

a = "hello world"

if a contains "hello" then
    msgbox a
end if

Cheers

 

[GlennUK]

Contain something or start with something? Anyway, have a look at Like operator:

a = "hello world"

If a Like "hello*" Then
    MsgBox a
End If

 

[yoko]

Ah yea that’s what I want.

I'm doing a search program and the user is going to enter a name. I need it to search for fields where it might contain other words or just an initial.

I've not used the like operator before.

Cheers!

 

[yoko]

Ok how about if I dont want it to be case sensortive

 

[GlennUK]

Put Option Compare Text as the first line in your module.