Using the StrConv keeps you in VB. Not that there's anything wrong with
jumping over to Excel.

--
Jim Rech
Excel MVP

"Frank Kabel" wrote in message
...
| Hi
| you may use
| application.worksheetfunction.Proper(...)
|
| --
| Regards
| Frank Kabel
| Frankfurt, Germany
|
|
| Saju wrote:
| Hi All,
| Is there an equivalent in VB for woorksheet function Proper
| (). Also, Is there an equvalent of Word's sentence case
| functionality in Excel and VB. Thanks for your comments
|
| Regards
| Saju