How to make word that is not in dictionary to red?

[london7871]

It is intended that if there is word that is not in dictionary,
the word will be capital and red.

How to revise the code

Please Login or Register  to view this content.

below:

Please Login or Register  to view this content.

[Kaper]

Probably you'll have to use

Please Login or Register  to view this content.

but (as almost always):


Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.

[london7871]

To simplify my query, misspelling word will turn red, and no need to capital.

[ikboy]

try this:

Please Login or Register  to view this content.

[Logit]

.
Another method :

Please Login or Register  to view this content.

[london7871]

Hi Logit, your VBA turn all words in cell to red if any word is misspelled.
It will be useful in future.