Proper case

A

Anthony Slater

Hi
I'm very new to word programming (quite effecient on excel)

I'm creatinging a user form for people to enter information. I've managed to
impliment all the user-entries at certain bookmarks using the following ode: -

Bookmarks("Company_Client").Range _
.InsertBefore Company_Client

So far so good.

Now I need to impliment some checks. One of them is to ensure that any text
entered is in a 'Proper' format (first letter of all words capitalised)

In excel, I used:-
Private Sub txtClientsurname_Change()
txtClientsurname.Value = Application.Proper(txtClientsurname.Value)
End Sub

But the 'Proper' function gives an error.

What is the Word equivalent for Proper?

TIA
 

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

Top