proper case

I'm new to Excel and MrExcel as well so hopefully I have posted this question in the right place. As I am quite new in VBA stuff, I'm having trouble getting my code to work in VBA. My requirement is to enforce UPPER case and Proper case on different cell ranges. I found below thread here...

- Within a userform, I have a textbox in which applicants type their last name - Some last names contain multiple capital letters (e.g. "McDonald") - The Proper Case function only capitalizes the first letter of each name and forces the remainder as lower case Question - Is there a way to...

My name is RAJ The above text is in one cell. I want "RAJ" to be written in proper case instead of upper case. It should be written as - My name is Raj Note : There is a break between the two lines above.

Uh, help please. I've got the simple macro to insert a column, use the Proper function, then copy/paste special over the original column and delete the inserted column. Trying to understand and use the vba examples I find is beyond by basic skill set . . . worst case I'll just use what is...

Hi all, In my Excel 2010 workbook I have a Workbook_BeforeClose event which applies a number of formatting rules across the sheet to maintain a level of uniformity. It is all working well as is, however the recent addition of applying the PROPER case formatting function has slowed things down...

Hi All, I have a list of Locations which can have values of, "AREA 1 NSW", "AREA 2 QLD" and few others as well. This list has 51 unique values and at this stage, "NSW" is the only value that the Proper formula doesn't work as I need. Desired Result. Area 1 NSW Area 2 Qld. I can use the...

I use: Sub ConvertToProper() Dim ws As Object Dim LCell As Range 'Turn off screen updating to increase performance Application.ScreenUpdating = False Application.Calculation = xlCalculationManual 'Move through each sheet in your spreadsheet For Each ws In...