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 70 71 72 73 74 75 76 77 78
| Private Sub cmbvalider_Click()
Dim ws As Worksheet
Dim newRow As Integer
Set ws = ActiveWorkbook.Worksheets(Feuil2.Range("B18").Value)
Select Case Me.ComboBox4.Value
Case "RECETTES divers"
newRow = 2
Do
newRow = newRow + 1
Loop Until ws.Cells(newRow, 1) = ""
ws.Cells(newRow, 1) = DateSerial(2015, Feuil2.Range("D18").Value, Me.ComboBox3.Value) 'date construite
ws.Cells(newRow, 6) = Feuil2.Cells(24, 2).Value
ws.Cells(newRow, 2) = Feuil2.Cells(19, 2).Value
'.....
'suite des affectations de données
Case "Ventes de Tableaux"
newRow = 10
Do
newRow = newRow + 1
Loop Until ws.Cells(newRow, 1) = ""
ws.Cells(newRow, 1) = DateSerial(2015, Feuil2.Range("D18").Value, Me.ComboBox3.Value)
ws.Cells(newRow, 2) = Feuil2.Cells(19, 2).Value
ws.Cells(newRow, 3) = Feuil2.Cells(20, 2).Value
ws.Cells(newRow, 4) = Feuil2.Cells(22, 2).Value
ws.Cells(newRow, 2) = Feuil2.Cells(23, 2).Value
ws.Cells(newRow, 6) = Feuil2.Cells(24, 2).Value
'.....
'suite des affectations de données
Case "Employer"
newRow = 18
Do
newRow = newRow + 1
Loop Until ws.Cells(newRow, 1) = ""
ws.Cells(newRow, 1) = DateSerial(2015, Feuil2.Range("D18").Value, Me.ComboBox3.Value)
ws.Cells(newRow, 2) = Feuil2.Cells(20, 2).Value
ws.Cells(newRow, 4) = Feuil2.Cells(21, 2).Value
ws.Cells(newRow, 6) = Feuil2.Cells(24, 2).Value
ws.Cells(newRow, 5) = Feuil2.Cells(25, 2).Value
'Case.... les autres cas
End Select
'ws.Cells(newRow, 1).Value = Me.ComboBox1.Value
'ws.Cells(newRow, 2).Value = Me.TextBox4.Value 'objet
'ws.Cells(newRow, 6).Value = Me.TxtSommes.Value
'ws.Cells(newRow, 1).Value = Me.ComboBox3.Value 'jours
End Sub
Private Sub cmdFermer_Click()
Me.Hide
End Sub
Private Sub ComboBox2_Change()
Worksheets(Me.ComboBox2.Text).Activate
End Sub
Private Sub Label1_Click()
End Sub
Private Sub UserForm1_Initialize()
ComboBox2.Text = "janvier "
Worksheets(Me.ComboBox2.Text).Activate
'Me.cmdmois.ControlSource = "donnees!D2"
'Me.cmdmois.RowSource = "donnees!A1:A4"
End Sub |
Partager