Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 08-26-2018, 03:53 PM
NoSparks NoSparks is offline Only lower case in column without formula Windows 7 64bit Only lower case in column without formula 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Only lower case in column without formula Issue with Accented Letter Replacement (Upper/Lower Case) onlywonderboy Word VBA 1 12-21-2017 08:57 PM
Only lower case in column without formula Change lower case to caps whole document lmb100 Word 4 08-07-2015 06:57 AM
Only lower case in column without formula Regular expressions: lower case after hyphen 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft