View Single Post
 
Old 08-26-2018, 03:53 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

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
Reply With Quote