check if contains words

**Leon V (AW)** · 04-03-2013, 11:39 AM

Is VBA capable of checking whether a cell contains words rather than just text? so "CRB DFMT" would return False or 0 but "Check on Darron Tate" would return True or 4.

eg:

Please Login or Register  to view this content.

etc...

Maybe through the use of the spell-check dictionary?

**Cheeky Charlie** · 04-03-2013, 12:28 PM

Checking within the current language is easier than checking several languages. Which do you need?

Here's a function which does what you describe. You could combine this with another function which cycles through different languages and returns the first to get a match. Bear in mind, it might be possible to have a string which is written in one language, within which some words are also words in another language (fort is a very different word in French and English). You might get false matches with a language cycle.

Please Login or Register  to view this content.

**Leon V (AW)** · 04-04-2013, 05:24 AM

So I could write it as an in cell function even? That makes the language check redundant as it was only going to be used to set the text in a userform. It is intended for use on an index of documents to display the number of documents in a given language (preferably the users set language) from their titles.

**Cheeky Charlie** · 04-04-2013, 05:33 AM

Yes, you can use functions like the above in cells or in VBA. It is demonstrated being used in VBA in my example. I don't see how that makes it redundant for setting language in a userform. I don't understand your third sentence, but in this scenario the standard is to ask the user their preferred language, rather than attempt to deduce it. Easier for you, not unpleasant for a user.

Hope this helps.