Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Excel Free Macros (VBA)

---

When 1 İs Entered İn The Cell On Your Sheet / Page, The Sentence Corresponding To One İs Automatically Written.

Online Excel and Excel Macro (VBA) Courses

Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Private Sub Worksheet_Change(ByVal Target As Excel.Range) If IsEmpty(Target) Then Exit Sub If Target = "1" Then Target = "İlçe Milli EĞitim Müdürlüğü" If Target = "2" Then Target = "Ahmet Aşkın KÜÇÜKKAYA" If Target = "3" Then Target = "Ordu İli Kabataş İlçesi" If Target = "4" Then Target = "Kabataş" 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

No	Macro Name
1	When 1 is entered in the cell on your sheet / page, the sentence corresponding to one is automatically written.
2	excel operators hk
3	Adding Serial Numbers: This macro code will help you automatically add serial numbers to your excel sheet. After you run this macro, it will display an input box where you must enter the maximum number for serial numbers, and then add a number to the column in a column.
4	assigns date to the next line when data is entered in certain cells on the sheet / page
5	inserts months as sheet / pages Specifies days in detail
6	Hide or show pivot table fields according to a specific criterion
7	inserts the date and time when data was entered into the cells where data was entered on the active sheet / page as a comment
8	specifies in detail how many formulas are in the book (on new sheet / page)
9	list formulas on new sheet / page
10	number of sheet / page prints with message box (prints even if the sheet / page is blank)
11	summer adds months to sheet / pages
12	Create your own extensions and functions in excel
13	When you click on any cell, it scrolls to the right and writes the numbers of the days in that month and color the weekends.
14	inserts double zeros at the beginning of numbers entered in specific cells on the active sheet / page
15	write the number you want to be colored on the sheet / page in msgbox
16	cell-related codes
17	lists all macros in macros in excel files in a folder of your choice
18	Create a user-defined menu / Create your own menu and assign a macro to them in the "Extensions" section
19	right mouse on active sheet / page menu
20	specifies in detail how many references the book contains (on new sheet / page)

---

---

Online Excel Courses

Online Excel Courses are here...

Click to see

Services

• Advanced Excel Courses
• Excel Macro Courses
• Comporate Valuation Courses
• Financial Mathematics
• Financial Modeling
• Comporate Valuation Services

How can we help you?

You can contact us about our services.

Contact us

Subscribe to our Youtube Channel?

Here are the videos that will make your life easier using Excel.

Subscribe Now

Keywords

Excel Videos Advanced Excel Courses Free Macros Free Excel Templates Excel Macro Courses