Capitalising first letter and lowercase all other in VBA



hi wanted to have my table automatically change all names entry by making the
first letter of every word in the names list upper and all other lettes to
lower and this what i wrote inbetween the sub and endsub and is not working.
'Capitalise the first letter of every word
'convert all other letters to lower case
object name then StrConv = (propercase). may i know if theres any help thanks

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question