How do I convert a line of text to title case?

rcbjr2 · #1 09-16-2020, 07:10 AM

Quote:

Originally Posted by Charles Kenyon

Here is what I'm running from Graham Mayor's vba examples:

When I run it on the text:
Save time in word with new buttons that show up where you need them.
It gives true title case including the word "you."
Save Time in Word with New Buttons That Show Up Where You Need Them.

I tried what I have from Paul's code, which does run fine on my computer, and it did not capitalize the "you." (You is in the exclusion list of the function.)
Save Time in Word with New Buttons That Show Up Where you Need Them.

The difference is in the exclusion lists, I expect. Paul's macro covers more things though.

Thanks for the add'l code and the comments about "you". If/when I get Paul's code wording, I will look at the exclusion lists. As I commented in other replies, the error arises because I had to copy the code into a Word doc and send that to the office and then past into the VBA editor but I am going to send my template home and copy the code directly because I just tried it and the quote pasted correctly when doing it directly.

-Rich

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
creating a new TITLE property from text already within document	smndnm	Word VBA	6	07-04-2014 08:27 PM
Stop review query when small case at beginning of line	dsrose	Word	2	01-22-2014 12:19 AM
True Title Case for First Row of All Tables	Marrick13	Word VBA	14	12-11-2013 09:12 PM
Custom Text Filter for this particular case	tinfanide	Excel	2	09-13-2011 05:08 AM
From all UPPER CASE to Proper Case	davers	Word	1	04-30-2009 12:41 PM