First Letters İn Cell Capital 2 Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Sayfanın kod bölümüne 'İlk harfler büyük Private Sub Worksheet_Change(ByVal Target As Range) Target.Value = WorksheetFunction.Proper(Target.Value) End Sub 'Hepsi Büyük Private Sub Worksheet_Change(ByVal Target As Range) Target.Value = WorksheetFunction.UPPER(Target.Value) End Sub 'Hepsi Küçük Private Sub Worksheet_Change(ByVal Target As Range) Target.Value = WorksheetFunction.Lower(Target.Value) End Sub Report problem with this macro This macro does not work. There's an error in the code. Other You can write your comments about the error in the box below. Report error ALL MACROS Youtube Channel The following macros may be useful for you. Similar Results NoMacro Name 1 first letters in cell capital 2 2 The first letters capital in the cell 1 3 excel operators hk 4 first letter capital others small (spelling) 5 Make the first letter of all words in the selected region capitalized and the other letters lowercase 6 Converting to Suitcase: And this code converts the selected text into the correct word that fills the first letter of capital with lowercase letters. 7 first letters of textbox are capitalized 8 register codes comparing first and last name 9 identifying unique (single) data entries 10 Collects cells that are red between a1: d20 11 Adds cells with red background color between cells A1: d20 12 sheet / page address and set column width 13 Adding Rows and Total Formula When Cell Changes 14 Shortening of sentences / Creating short sentences using the first letters of the words in a sentence 15 Search for a text / text in all open Excel files 16 inserts months as sheet / pages Specifies days in detail 17 number of sheet / page prints with message box (prints even if the sheet / page is blank) 18 giving sheet / page insertion sequence number 19 import "first name" information in separate cells into separate cells 20 adding two lines and removing total