Wildcard Usage (AXP / VBA)

[santosm]

How do you use reference to a wildcard character within VBA? I am trying to use something like:

if strTest = "test*" then..... and this doesn't work because it is seeing that as a literal string. How do I make it so that all entries starting with "test" show up?

Thanks,
Mark

[SteveH]

If Left(strTest,4) = "test" Then


should do the job.

[santosm]

Thanks Steve,
Will try it!

Mark

[HansV]

Steve's solution will work fine. Another way to do it is

If strTest Like "test*" Then