VBA "Like"

[Dryver14]

When you use like in vba does it look up actual values "Text" or similar?

This an example from a help file

MsgBox UCase(ActiveCell.Value) Like "*ASIA*"

what is this looking for?

 

[Ron Coderre]

This example: MsgBox UCase(ActiveCell.Value) Like "*ASIA*"
is using the asterisk wildcard...which indicates zero or more characters.

The code displays a TRUE/FALSE value in a message box, based on this statement:
The current cell's value, converted to upper case, contains the word "ASIA" anyplace in the value.

Does that help?

 

[Dryver14]

Thanks Ron,

Yes it does help, I will put a few sets of code together for myself to have a play with it.

Cheers,
Kev