And VBA also has a StrComp function.

You could use that to test for exact matches, too.

phil wrote:

is it possible to check the case of a letter. All the functions i found in
help seem to be able to convert text to a particular case but not check the
case

--

Dave Peterson