![]() |
#5
|
|||
|
|||
![]()
Try this
Code:
Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range, cel As Range With ActiveSheet Set rng = Intersect(.Columns(3), .UsedRange) If Not rng Is Nothing Then Application.EnableEvents = False For Each cel In rng cel.Value = LCase(cel.Value) Next cel Application.EnableEvents = True End If End With End Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
onlywonderboy | Word VBA | 1 | 12-21-2017 08:57 PM |
![]() |
lmb100 | Word | 4 | 08-07-2015 06:57 AM |
![]() |
SusanG | Word | 2 | 06-06-2012 11:58 PM |
Search for paras beginging with a lower case | MShroff | Word | 1 | 10-19-2010 06:41 AM |
Upper to lower case | jd | Excel | 1 | 04-28-2006 07:40 AM |