VBA Sentence case with exceptions

[tony4444]

Hello,

I am trying to perform sentence case on a cell with some exceptions.

As an example lets say I have a cell that has the text "MARGARINE IS BETTER THAN BUTTER, TRUE OR FALSE".
I would like to run some VBA to change this too "Margarine is better than butter, TRUE or FALSE".
Currently I have this code:

Please Login or Register  to view this content.

This returns "Margarine is better than butter, true or false".

I would like the true and false to stay in CAPS and also be able to add other exemptions as needed.

Thanks in advance

Tony

[Kenneth Hobson]

Please Login or Register  to view this content.

[6StringJazzer]

I have not tested Kenneth's solution, which may meet your needs perfectly. However, I developed a different approach from the ground up using words instead of letters but was unable to post earlier due to server issues.

Add more words to the array at the bottom to add more exception words.

Also, I recommend you use Option Explicit to guarantee that all variables are declared.


I was unable to post my code here because the nanny service thinks it has a SQL injection attack, but here is the test file.

[tony4444]

Kenneth that worked perfectly. Also allows me to exempt as Proper case if needed, brilliant.
Thank you

[zhead]

Kenneth, I hope I am not breaking any rules here but I would like to know in your macro above say instead of TRUE & FALSE you were to use IN & OUT. How would you prevent it from being applies per say to words like DROPOUT or INPUT

[6StringJazzer]

Kenneth, I hope I am not breaking any rules here

Sorry to say that you are. Please start a new thread with your question, and feel free to copy Kenneth's code and post it there. You may also include a link back to this thread.

Since you are not familiar with the rules please take two minutes to review our rules. There aren't many, and they are all important.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

[zhead]

Thanks 6StrinJazzer. So can I reference this post or copy the code from here and paste it in a new post?

[AliGW]

@zhead

Yes. Copy the code and post a link back to this thread. Thanks.