finds data 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)

Finds Data

Online Excel and Excel Macro (VBA) Courses

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
VERİLERİ BULUR
Private Sub CommandButton6_Click()
    Dim bak As Range
    For Each bak In Range("B1:B" & WorksheetFunction.CountA(Range("B1:B65000")))
        If StrConv(bak.Value, vbUpperCase) = StrConv(ComboBox1.Value, vbUpperCase) Then
            bak.Select
            TextBox1.Value = ActiveCell.Offset(0, -1).Value
            TextBox2.Value = ActiveCell.Offset(0, 1).Value
            TextBox3.Value = ActiveCell.Offset(0, 2).Value
            Exit Sub
        End If
    Next bak
    MsgBox "Aradığınız isimde bir kayıt bulunamadı"
End Sub
'VERİ ARATIRKEN SÜTUN SEÇİMİNİ GENİŞ TUTARSAK BÜTÜN SAYFADA VERİ ARATABİLİRİZ.
Private Sub CommandButton1_Click()
    Dim bak As Range
    For Each bak In Range("a1:ıv" & WorksheetFunction.CountA(Range("a1:ıv65000")))
        If StrConv(bak.Value, vbUpperCase) = StrConv(ComboBox1.Value, vbUpperCase) Then
            bak.Select

Exit Sub
        End If
    Next bak
          MsgBox "Aradığınız isimde bir kayıt bulunamadı"
       
End Sub

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	finds data
2	sorts data and finds name
3	sorts data and finds name
4	finds if there is a print area and indicates by message
5	column finds full cells and encapsulates print area
6	Finds filled cells in column a and encapsulates print area
7	finds the last day of the month writes to the active cell
8	finds formulas on active sheet / page lists new sheet / page
9	api that finds which key is pressed
10	code that finds the number of sheet / pages 1
11	code that finds the number of sheet / pages 2
12	finds searched cell reports
13	finds searches in abc column
14	macro that finds the IP number
15	finds how many rows are selected
16	finds the largest value in selected cells and makes them bold
17	finds the last space word = pir (a3)
18	Finds if there is a written sheet / page in the cell
19	remove sheet / page protections
20	prints cells with data

Excel Free Macros (VBA)

Finds Data

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords