Making font to be in small size

[Guest]

Could someone help me how to make sure that text entered in a column will be
without capital characters (only small letters)

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/case.htm

You may also try to use the following:
- select the cell (e.g. cell C1)
- goto 'Data - Validation' and choose custom
- enter the following formula:
=EXACT(C1,LOWER(C1))

 

[Gord Dibben]

Ruslan

The code you want to use is the Event code from Chip's page.

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Not Application.Intersect(Target, Range("A1:A10")) Is Nothing Then
Target(1).Value = UCase(Target(1).Value)
End If
Application.EnableEvents = True
End Sub

Copy this code then right-click on your worksheet tab and "View Code"

Paste in there.

Change the UCase to LCase and adjust the range A1:A10 to whatever you wish.

Gord Dibben Excel MVP

 

[Dave Peterson]

You did put the code behind the correct worksheet?

And you did your typing in the range that you specified in the code?

(It won't affect values already there, but if you type something new, it should
work.)

If you still have trouble, post your version of the routine.

 

[Gord Dibben]

Ruslan

What Dave said.....<g>

Gord

You did put the code behind the correct worksheet?

And you did your typing in the range that you specified in the code?

(It won't affect values already there, but if you type something new, it should
work.)

If you still have trouble, post your version of the routine.