1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
| Private Sub CommandButton1_Click()
Dim I As Integer
For I = 5 To 5000
If Cells(I, 8).Value > 20 Then
UserForm.TextBox1.Value = Sheets("Source").Cells(I, 7).Value
UserForm.TextBox2.Value = Sheets("Source").Cells(I, 9).Value
'Sheets("source").Cells(I, 7).Select
Sheets("Source").Cells(I, 7).Value = UserForm.TextBox1.Value
End If
Next I
'UserForm1.TextBox1.Value = Sheets("Source").Cells(I, 7).Value
'UserForm1.TextBox2.Value = Sheets("Source").Cells(I, 9).Value
'Range("A1").Value = Val(TextBox1.Text)
'Value(TextBox1.Text) = Sheets("Source").Cells(I, 7).Value
'Value(TextBox2.Text) = Sheets("Source").Cells(I, 9).Value
'Sheets("source").Cells(I, 7).Select
'UserForm1.newsearch_value
'Sheets("Source").Cells(I, 7).Value = Me.TextBox1
' Sheets("source").Cells(I, 7).Select
'Txtnom = Cells(I, 7)
' NEWVAL = InputBox("NBRE DE CARACTERES >20" & Cells(I, 9).Value SAISIR LE NOUVEAU REPERE TOPO")
'Cells(I, 7).Value = NEWVAl
'Unload UserForm1
End Sub |
Partager