record on the same ones Free Excel Macros (VBA) | Excel Programs

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)

Record On The Same Ones

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 cmbkaydet_Click() 
Dim i As Integer 
Sheets("Sayfa1").Select 
'*** önce textoxları kontrol edelim 
If txtadet.Value = "" Or txtkilo.Value = "" Or txtfiyat.Value = "" Then 
    MsgBox "Eksik taımlama yapmışsınız!" 
    Exit Sub 
End If 
Dim j As Integer, k As Integer 
j = 1 
k = 3 
BASADONELIM: 
'**** Şimdi de aynı fiyattan varmı diye bakalım 
'**** varsa üzerine toplayalım 
'**** yoksa alttaki boş satıra gidelim 
For i = k To k + 15 
    If txtfiyat.Value * 1 = Cells(i, j + 2) Then 
        Cells(i, j) = Cells(i, j) + txtadet.Value 
        Cells(i, j + 1) = Cells(i, j + 1) + txtkilo.Value 
        Cells(i, j + 2) = Cells(i, j + 2) 
        GoTo AtlaSona 
    Else 
    If Cells(i, j + 2).Value = "" Then 
        Cells(i, j) = txtadet.Value 
        Cells(i, j + 1) = txtkilo.Value 
        Cells(i, j + 2) = txtfiyat.Value 
        GoTo AtlaSona 
    End If 
    End If 
Next i 
    If i = k + 16 And j  -

Report problem with this macro

Report error

ALL MACROS

Youtube Channel
The following macros may be useful for you.

Similar Results
No	Macro Name
1	record on the same ones
2	record on multiple sheet / pages with the same macro
3	excel operators hk
4	recording on the same
5	Leaves 1 of the same ones in column a and queues
6	Separates the same ones in column a as sheet / page space
7	records detailed formatted cells on the records sheet / page
8	auto macro recording
9	listing one of the same ones in the combobox
10	Compares the names in column b against column a and deletes the same ones from column a
11	a byi compare the same ones cye different ones dye
12	Deletes the same ones in column b and leaves 1
13	Separates the same ones in column a as sheet / page space2
14	Delete all modules in an Excel file at the same time
15	adding two lines and removing total
16	double record blocking (macros solution)
17	Codes that prevent and open the vba window and access codes
18	It is forbidden to enter double records in column a1 (if you enter the cell manually, it deletes)
19	combobox unique record
20	re-register event in duplicate records

Excel Free Macros (VBA)

Record On The Same Ones

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords