VBA has its own builtin function, too:

Option Explicit
Sub testme()
Dim myStr As String
myStr = "now is the TIME FOr all good MEN TO COME..."
myStr = StrConv(myStr, vbProperCase)
MsgBox myStr
End Sub



"!!!" wrote:

What is the vba equivalent to the worksheet proper
function?

--

Dave Peterson