Convert text to upper

[jasonmcbride]

Ok before you say "Easy, just use the UPPER function" that's not not what I want.
If I type abc123 in cell A1 I want it to convert to ABC123 in A1 as soon as I hit enter. I don't think it is possible, but I thought I'd ask.
Thanks in advance
Jase

[Kieran]

Jase,

it is possibel, but you will need to use the worksheet change event to run a macro.

Paste the following code into the worksheet code for the sheet in question and it should do what you want.

Private Sub Worksheet_Change(ByVal Target As Range) 
    Target.Value = UCase(Target.Text) 
End Sub  

[jasonmcbride]

Thanks Kieran,how do I get to the worksheet code?

[Kieran]

An existing example of this can be done is found athere.
Note how this example is fairly close to your orginal request, did you search the forum first?

[jasonmcbride]

Thanks mate, that worked a treat. Can you make this cell or range specific instead of the whole worksheet?
Jase

[Kieran]

Replace the code with this below

It restricts the action to A1:D10. Change the reference as appropriate.

Please Login or Register  to view this content.

[jasonmcbride]

Thanks mate, I appreciate all your help.
Jase
ps, how do I mark this as solved? or is that something the moderators do?

[Kieran]

I really don't know about marking it as solved.
does the thread tools drop-down at the top of the panel show anyting to you (as the creator of the thread)