G Guest Nov 6, 2003 #1 Is there a function in VBA that is equal to the Proper function in excel? I know there is a Ucase and a Lcase...
Is there a function in VBA that is equal to the Proper function in excel? I know there is a Ucase and a Lcase...
C Chip Pearson Nov 6, 2003 #2 George, Use the StrConv function. E.g., Result = StrConv(Text, vbProperCase) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed) George said: Is there a function in VBA that is equal to the Proper function in excel? Click to expand... I know there is a Ucase and a Lcase...
George, Use the StrConv function. E.g., Result = StrConv(Text, vbProperCase) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed) George said: Is there a function in VBA that is equal to the Proper function in excel? Click to expand... I know there is a Ucase and a Lcase...
