Proper Case

[Brian]

I have a column on the worksheet which contains names. I need the
name and initials always to be entered in Proper Case. Presently the
names are entered by means of an input box. My problem is some names
are entered in lowercase and some in uppercase. The name needs to
look like this "Black B F". How do force this entry or let the macro
(or VB code) convert this to the proper case.

Any help would be appreciated

 

[Bampah]

Brian
An Excel add-in called Excel Manager contains loads of neat utilities, one
of which will do exactly what you want.
Sorry but I can't remember the link to it but a search via Google should do
the trick
Rob