VBA to capitalize every proper word in a sentence

[BFLO2000]

Is there any way using VBA to capitalize every proper word in a sentence?

For example for the sentence:

Beginning in 1910, the automobile industry sprang up in Detroit with 125 different auto companies. The rise of the city’s automobile industry spawned an upward movement of population and growth, with companies recruiting workers from as far away as Mexico and Europe.

I would like to also capitalize automobile, city's, industry, population, growth, workers.

Thanks

 

[DanteAmor]

Is there any way using VBA to capitalize every proper word in a sentence?

For example for the sentence:

Beginning in 1910, the automobile industry sprang up in Detroit with 125 different auto companies. The rise of the city’s automobile industry spawned an upward movement of population and growth, with companies recruiting workers from as far away as Mexico and Europe.

I would like to also capitalize automobile, city's, industry, population, growth, workers.

Thanks

Do you want all capitalized words or only some?

example = WorksheetFunction.Proper("Beginning in 1910, the automobile industry sprang up in Detroit with 125 different auto companies. The rise of the city’s automobile industry spawned an upward movement of population and growth, with companies recruiting workers from as far away as Mexico and Europe.")

 

[footoo]

If you want to capitalise nouns, have a look here :
https://www.mrexcel.com/forum/excel-questions/196870-recognising-nouns-verbs-etc.html