Force characters to upper case as text is typed into cell

All,

Maybe this isn't possible, I have looked around and I keep finding this method:

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.

Re: Upper Case Cell as Typing Occurs

AAE,

My post is asking how to make the cell change to upper case as I type. Is that possible?

The second thing of this happening is how much room is left to type, which I will know when it does the first, no matter if you have cap locks on or not, it will upper case each letter as you type it, not after you leave the cell or not at all in the case of the "On Change" worksheet event I posted.

So the Title *is* what I am after, once that happens the second desire (knowing how much room is left as I type) is apparent. I could changed the end of it to "as you type." I do see how the length can be seen as the ultimate goal, however it's really Upper Case as I am Typing in the Cell.

The column width is 44.14, I just need to automatically convert what is being typed to upper case, with out having to rely on someone doing it right and typing it all in caps... I have to fix so many entries, so looking for a way to fix it.

Re: Upper Case Cell as Typing Occurs

Thanks Attilas.. I will post if I find anything too.

Re: Upper Case Cell as Typing Occurs

cytop,

I was worried about that.. well not worried, but figured.. I knew I could do it via userform/textbox input, but this particular spreadsheet is sheet based (for the most part) Thanks!

Joe