ProperCase in vba

Hi all,

I'm trying to convert text from an inputbox to ProperCase and display that into a messagebox. I need to have the user input first and last name inside a input box in my main sub then have it call a function that takes whatever was enter and converts it to ProperCase then goes back to my main sub and display the name correctly. Below is my code but I can only get it to work inside my main sub.

Please Login or Register  to view this content.

Hi Noodle,

Oddly enough, this sounds like a homework assignment as there is no real reason to do it this way. One line of code can do everything.

Please Login or Register  to view this content.