history transactions 1 Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Function ayekle(EklenecekSure As Integer, ilkTarih As Date) 
ayekle = DateAdd("m", EklenecekSure, ilkTarih) 
End Function 
Function yilekle(EklenecekSure As Integer, ilkTarih As Date) 
yilekle = DateAdd("yyyy", EklenecekSure, ilkTarih) 
End Function 
Function gunekle(EklenecekSure As Integer, ilkTarih As Date) 
gunekle = DateAdd("d", EklenecekSure, ilkTarih) 
End Function 
Function ayfarki(ilkTarih As Date, sonTarih As Date) 
ayfarki = DateDiff("m", ilkTarih, sonTarih) 
End Function 
Function yilfarki(ilkTarih As Date, sonTarih As Date) 
yilfarki = DateDiff("yyyy", ilkTarih, sonTarih) 
End Function 
Function gunfarki(ilkTarih As Date, sonTarih As Date) 
gunfarki = DateDiff("d", ilkTarih, sonTarih) 
End Function 
Function ayinsonu(tarih As Date) 
Dim ay As Integer 
Dim yil As Integer 
ay = Month(tarih) 
yil = Year(tarih) 
ayinsonu = IIf(ay = 2, IIf((yil Mod 4) > 0, 28, 29), IIf(ay = 4, 30, IIf(ay = 6, 30, IIf(ay = 9, 30, IIf(ay = 11, 30, 31))))) 
End Function 
Function yildakigun(tarih As Date) 
Dim yil As Integer 
yil = Year(tarih) 
yildakigun = IIf((yil Mod 4) > 0, 365, 366) 
End Function

No	Macro Name
1	history transactions 1
2	excel operators hk
3	link to a1 and open outloook with mail in a1
4	giving and opening email links
5	excel outlook
6	undo --- undo
7	right word retrieval
8	history operations 2
9	reading history as text to macro.
10	writes the names of all sheet / pages from the active sheet / page and cell and adds a link to the sheet / pages
11	list of all macros
12	special gluing options / format gluing design gluing formula gluing column width gluing transpose gluing
13	how to remove the single quotation mark () at the beginning of the cells with the macro.
14	identifying unique (single) data entries
15	send alert e-mail from microsoft outlook
16	macro run every 5 minutes
17	transfer data from listbox to sheet / page
18	filtered transfer
19	2 Move data between listboxes
20	only one view of data in the combobox

Excel Free Macros (VBA)

History Transactions 1

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords