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 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69
| Option Explicit
Dim ligne As Integer, i As Integer, j As Integer, y As Byte, tableau As Variant, x As Integer
Private Sub ComboBox1_Click()
If ComboBox1.ListIndex = -1 Then Exit Sub
For i = 1 To 1
For j = 2 To UBound(tablo)
If CStr(tableau(j, i)) = ComboBox1 Then ligne = j
Next j
Next i
With Me
For i = 1 To 8
.Controls("TextBox" & i) = Cells(ligne, i)
Next i
End With
End Sub
Private Sub CommandButton1_Click()
With Me
For i = 1 To 8
If IsNumeric(.Controls("TextBox" & i)) Then
Cells(ligne, i) = CDbl(.Controls("TextBox" & i))
Else
Cells(ligne, i) = .Controls("TextBox" & i)
End If
Next i
End With
End Sub
Private Sub ComboBox1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal x As Single, ByVal y As Single)
ComboBox1 .SetFocus
ComboBox1 .DropDown
End Sub
Private Sub CommandButton2_Click()
x = Sheets("sheet4").Range("A65536").End(xlUp).Row + 1
For i = 1 To 8
Sheets("sheet4").Cells(x, i) = Controls("Textbox" & i)
Next i
Unload Me
fatis.Show
Beep
End Sub
Private Sub CommandButton3_Click()
Unload Me
End Sub
Private Sub UserForm_Click()
End Sub
Private Sub UserForm_Initialize()
tableau = Range("A1:A" & Range("A65536").End(xlUp).Row)
For i = 1 To 1
For j = 2 To UBound(tableau)
If tableau(j, i) <> "" Then ComboBox1.AddItem tablo(j, i)
Next j
Next i
For y = 1 To 8
Controls("label" & y).Caption = Sheets("sheet4").Range("a1:h8").Cells(1, y) & " ==>"
Next y
Label2.Caption = "nb= " & Application.WorksheetFunction.CountA(Range("A:A")) - 1
End Sub |
Partager