با سلام
کد PHP:
Private Sub CommandButton1_Click()
If TextBox1 = TextBox2 And TextBox2 = TextBox3 Then
MsgBox "not ok"
TextBox1 = ""
TextBox2 = ""
TextBox3 = ""
Exit Sub
End If
T = 1
Z1 = Sheet1.Cells(Sheet1.Rows.Count, "A").End(xlUp).Row
For j = 1 To Z1
If TextBox1 = Range("A" & j) And TextBox2 = Range("B" & j) And TextBox3 = Range("C" & j) Then
MsgBox "not ok"
TextBox1 = ""
TextBox2 = ""
TextBox3 = ""
T = 2
Exit Sub
End If
Next
If T = 1 Then
Range("A" & Z1 + 1) = TextBox1
Range("B" & Z1 + 1) = TextBox2
Range("C" & Z1 + 1) = TextBox3
TextBox1 = ""
TextBox2 = ""
TextBox3 = ""
End If
End Sub
علاقه مندی ها (Bookmarks)