still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 847
- Office Version
- 365
- Platform
- Windows
Hi
Is there a way to have a Row (C) to default to proper case?
Roc (C) will always be a string.
I was thinking of using an event change macro but anything above the new entry would already be in proper case and wouldn't the wait time be long when i'm down to, say C900?
I tried Data Validation, but it only alerts if the the string is not in proper case. it doesn't change the string.
What I use now is the following macro:
After I type the string, I have an icon on the ribbon to change the case. I would like to have it change when i leave the cell
mike
Is there a way to have a Row (C) to default to proper case?
Roc (C) will always be a string.
I was thinking of using an event change macro but anything above the new entry would already be in proper case and wouldn't the wait time be long when i'm down to, say C900?
I tried Data Validation, but it only alerts if the the string is not in proper case. it doesn't change the string.
What I use now is the following macro:
VBA Code:
Sub Propercase()
Dim c As Range
For Each c In Selection
c.Value = StrConv(c.Value, vbProperCase)
Next c
End Sub
mike