Halo Abang dan Nona Master semua, mau tanya nih:
saya punya Button pencarian data siswa, sbb:
Private Sub BtnCariData_Click() On Error Resume Next Dim Ws As Worksheet Dim Kode, Cari As Variant Dim Baris As Long Set Ws = Worksheets("PusatDataSiswa") Kode = Me.txtNoSiswa.Text With Ws.Range("B3:B10") Set Cari = .Find(Kode, LookAt:=xlWhole) If Not Cari Is Nothing Then Baris = Cari.Row With Form1 .txtNoSiswa.Value = Ws.Cells(Baris, 2).Value .txtNamaSiswa.Value = Ws.Cells(Baris, 3).Value .cmbWali.Value = Ws.Cells(Baris, 4).Value If Ws.Cells(Baris, 5).Value = "Pria" Then opbPria.Value = True: If Ws.Cells(Baris, 5).Value = "Wanita" Then opbWanita.Value = True: .txtAlamatAsal.Value = Ws.Cells(Baris, 6).Value .txtNomorHP.Value = Ws.Cells(Baris, 7).Value End With End If End With End Sub
Ketika data nomor siswa yang dicari tidak ada, saya ingin memasukkan pesan berikut:
MsgBox "Data yang anda cari tidak ada"
dimanakah saya harus memasukkan pesan tersebut?
thanxs