George,

Use the StrConv function. E.g.,

Result = StrConv(Text, vbProperCase)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"George" wrote in message
...
Is there a function in VBA that is equal to the Proper function in excel?
I know there is a Ucase and a Lcase...