Excel: Capitalize first letter of first word only

Is there a way I can capitalize the first letter of the first word only in a Userform Textbox, rather than every word? Better still, how about what I would call true propercase, where the first word of each sentence is capitalized, rather than the usual propercase which in my view is not accurate because it capitalizes every word.

This question generated 17 answers. To proceed to the answers, click here.

This thread is current as of June 10, 2015.

For more resources for Microsoft Excel