Proper Case

[TO]

Hello all,

Is there a function in VB similar to the "Proper"
function. I would like the caption of a label show up
proper.

i.e. lblName.caption = Proper(txtName.value)
I know this doesn't work, but is there some way to
accomplish something similar.

Thanks

 

[Leo Heuser]

Try

lblName.caption = Application.WorksheetFunction.Proper(txtName.value)

 

[Chip Pearson]

Try something like the following:

Me.lblName.Caption = StrConv(Me.txtName.Text, vbProperCase)


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

 

[Ron de Bruin]

Try something like this

Me.Label1.Caption = StrConv("your text", vbProperCase)

 

[Tom Ogilvy]

lblName.caption = StrConv(txtName.value, vbProperCase)

 

[David McRitchie]

use StrConv(txtName.value,vbProperCase)
You could use application.proper(txtName.value)
but the StrConv is part of VBA

I have macros for converting a selection
http://www.mvps.org/dmcritchie/excel/proper.htm