All,
Maybe this isn't possible, I have looked around and I keep finding this method:
Code
Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If Not .HasFormula Then
.Value = UCase(.Value)
End If
End With
End Sub
However, the column I am working in (Column H) is limited in size, thus I have typed information in the cell, upper cased it and then found out my narrative was too long for the cell, after it was converted to Upper Case.
I can simply hit, Caps Lock, but this needs to be dummy proof for others. We have had others fill out the form, all in lower case or proper case and then I had to go in and edit the entryies. So I thought, take the problem out, auto convert the text.
The above will (sometimes) convert the text after you leave the cell, this is close to what I need, but would rather know how much room I have as I type.
Ideas? Thanks in Advance.