ExcelBanter - "Proper" string function

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - "Proper" string function (https://www.excelbanter.com/excel-programming/281724-proper-string-function.html)

George[_16_]

"Proper" string function

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

Chip Pearson

"Proper" string function

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...

George[_16_]

"Proper" string function

Thanks Chip!

All times are GMT +1. The time now is 01:37 PM.