uppercase 1

[Qube]

Is it possible to make text entered into a cell in Excel all uppercase even if entered in lower case?

If so please explain how

Thanks

Lee

 

[xlbo]

need to use the worksheet change event

then insert this code

target.value = uCase(target.value)

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes

 

[ssVBAdev]

use the ucase() fucntion in VBA or the upper() function in the worksheet

 

[Qube]

Wow thanks that was most helpful and very quick

 

[KenWright]

Careful though, you will turn any formuls into text if you don't trap for formulas. Following is courtesy of Chip Pearson:-

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error GoTo ErrHandler
Application.EnableEvents = False
If Target.HasFormula = False Then
Target.Value = UCase(Target.Value)
End If
ErrHandler:
Application.EnableEvents = True
End Sub

Regards
Ken..............