converts text to uppercase & lowercase Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Metni büyük harfli yapmak için şu makroyu kullanın: 
Sub BuyukHarf() 
For Each c In Selection.Cells 
c.Value=Ucase$(c.Value) 
Next c 
End Sub 
Metni küçük harf yapmak içinse şu makroyu kullanın: 
Sub KucukHarf() 
For Each c In Selection.Cells 
c.Value=Lcase$(c.Value) 
Next c 
End Sub 
'VERİLEN HÜCRE ÖLÇÜTÜNE GÖRE SAYFAYA YAZILANLARI BÜYÜK HARFE ÇEVİRİR.
Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim RaBereich As Range, RaZelle As Range
    Application.EnableEvents = False
    Set RaBereich = Range("a1:ı1000")
    Application.EnableEvents = False
    For Each RaZelle In Range(Target.Address)
        If Not Intersect(RaZelle, RaBereich) Is Nothing Then
            RaZelle.Value = UCase(RaZelle.Value)
        End If
    Next RaZelle
    Application.EnableEvents = True
    Set RaBereich = Nothing
End Sub
'VERİLEN HÜCRE ÖLÇÜTÜNE GÖRE SAYFAYA YAZILANLARIN BAŞ HARFİNİ BÜYÜK HARFE ÇEVİRİR.
Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim RaBereich As Range, RaZelle As Range
    Application.EnableEvents = False
    Set RaBereich = Range("a1:ı1000")
    Application.EnableEvents = False
    For Each RaZelle In Range(Target.Address)
        If Not Intersect(RaZelle, RaBereich) Is Nothing Then
            If RaZelle  "" Then
                RaZelle.Value = UCase(Mid(RaZelle.Value, 1, 1)) _
                    & LCase(Mid(RaZelle.Value, 2, Len(RaZelle.Value) - 1))
            End If
        End If
    Next RaZelle
    Application.EnableEvents = True
    Set RaBereich = Nothing
End Sub

No	Macro Name
1	converts text to uppercase & lowercase
2	converts text to uppercase & lowercase
3	excel operators hk
4	Specifies the converted cells that converts uppercase to lowercase. (Toggle)
5	Convert selected cells to uppercase or lowercase with one click
6	Convert Small Case: This code helps you convert selected text to lower case text. & Nbsp; Select a range of cells that contain your text and run this code. If a cell has any value other than a number or text, the value will remain the same.
7	Converts the first letters of a1-a5 to uppercase
8	Convert to Uppercase: Select cells and run this code. Checks each cell of the selected range and then converts it to uppercase text.
9	Converting to Suitcase: And this code converts the selected text into the correct word that fills the first letter of capital with lowercase letters.
10	selects full cells and converts them to uppercase
11	translate the number / number into English (in dollars and cents)
12	find-delete-change-save codes
13	saves data
14	find-change-delete-save macro
15	automatic image fetch
16	data changes
17	a1: a50 full names search in textbox list in listbox
18	TreeView
19	finds data
20	converts the number in the cell to lower or upper case and normal. h2o co2

Excel Free Macros (VBA)

Converts Text To Uppercase & Lowercase

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords