change first letter of the text or sentence using vba

[coolman]

hi all

are there any syntax of how to change only the first word of the text or sentence to upper cap format using vba?

so far in vba excel, there are only all lower cap, all upper cap and proper sentence.

 

[StephenCrump]

Your heading says "first letter", but your question says "first word". Which do you want?

Will the text string contain one sentence? Or potentially more than one sentence, presumably delineated with a "." character?

Perhaps you could provide some examples to clarify?

 

[coolman]

my apologies for the miscommunication

for example "john is a boy."

so i would like it to become "John is a boy."

Your heading says "first letter", but your question says "first word". Which do you want?

Will the text string contain one sentence? Or potentially more than one sentence, presumably delineated with a "." character?

Perhaps you could provide some examples to clarify?

 

[Rick Rothstein]

my apologies for the miscommunication

for example "john is a boy."

so i would like it to become "John is a boy."

Perhaps you would want to answer the other question Stephen asked you; namely, will the text string contain one sentence? Or potentially more than one sentence, presumably delineated with a "." character?"