duffmoi
Messages postés
11
Date d'inscription
mercredi 23 août 2006
Statut
Membre
Dernière intervention
18 février 2010
13 juil. 2007 à 09:23
merci pour ta rapiditer
Heu bonne question si ce n'est pas le cas il faut rajouter une routine d'indentification aie
voici mon code il est tout simple
jutilise des userfomes pour simplifier la manipulation, et j'aimerai que ça marche aussi sur le net.
Private Sub CommandButton1_Click()
'Déclaration des variables
Dim nb1 As Integer, nb2 As Double, nb3 As Double, nb4 As Double, nb5 As Double, nb6 As Double, i As Double, nb7 As Double, nb8 As Double, nb9 As Double
'selection de la ligne a remplir
i = 3
Do
i = i + 1
Loop Until Cells(i, 1) = ""
'ecriture des données
'tableau general
UserForm1.Show
'choix du groupe
UserForm2.Show
'choix de l'equipe
Select Case Cells(29, 21)
Case "ICER"
Cells(19, 21) = "IPTV"
MsgBox "Team IPTV selected"
Case "ISSO"
Cells(19, 21) = "ISSO"
MsgBox "Team ISSO selected"
Case "ITS"
UserForm4.Show
Case "MGT"
Cells(19, 21) = "MGT"
MsgBox "Team MGT selected"
Case "MSDR"
UserForm5.Show
Case "PSSTI"
UserForm6.Show
Case "SOR"
UserForm7.Show
Case "WDTS"
UserForm8.Show
Case Else
MsgBox "dammed"
End Select
'obsevation
UserForm3.Show
'concatenation de la date
Cells(5, 21) = Cells(3, 18) & " " & Cells(3, 19) & " " & Cells(3, 20)
'memorisation des valeures saisies
Cells(i, 1) = i - 3
Cells(i, 2) = Cells(7, 21)
Cells(i, 3) = Cells(9, 21)
Cells(i, 4) = Cells(11, 21)
Cells(i, 5) = Cells(13, 21)
Cells(i, 6) = Cells(15, 21)
Cells(i, 7) = Cells(17, 21)
Cells(i, 8) = Cells(19, 21)
Cells(i, 9) = Cells(21, 21)
Cells(i, 10) = Cells(23, 21)
Cells(i, 11) = Cells(5, 21)
Cells(i, 12) = Cells(27, 21)
Cells(i, 13) = Cells(25, 21)
End Sub
Private Sub CommandButton2_Click()
CommandButton1.Visible = False
CommandButton2.Visible = False
CommandButton3.Visible = False
Range("A1:M33").Select
Selection.PrintOut Copies:=1, Collate:=True
CommandButton1.Visible = True
CommandButton2.Visible = True
CommandButton2.Visible = True
Cells(1, 1).Select
' Application.Quit
End Sub
Private Sub CommandButton3_Click()
'Déclaration des variables
Dim nb1 As Integer, nb2 As Double, nb3 As Double, nb4 As Double, nb5 As Double, nb6 As Double, i As Double, nb7 As Double, nb8 As Double, nb9 As Double
'selection de la ligne a remplir
i = 3
Do
i = i + 1
Loop Until Cells(i, 1) = ""
'ecriture des données
'tableau general
UserForm1.Show
'choix du groupe
laba:
UserForm2.Show
'choix de l'equipe
Select Case Cells(29, 21)
Case "ICER"
Cells(19, 21) = "IPTV"
MsgBox "Team IPTV selected"
Case "ISSO"
Cells(19, 21) = "ISSO"
MsgBox "Team ISSO selected"
Case "ITS"
UserForm4.Show
Case "MGT"
Cells(19, 21) = "MGT"
MsgBox "Team MGT selected"
Case "MSDR"
UserForm5.Show
Case "PSSTI"
UserForm6.Show
Case "SOR"
UserForm7.Show
Case "WDTS"
UserForm8.Show
Case Else
GoTo laba
MsgBox "dammed"
End Select
'obsevation
UserForm3.Show
'concatenation de la date
Cells(5, 21) = Cells(3, 18) & " " & Cells(3, 19) & " " & Cells(3, 20)
'memorisation des valeures saisies
Cells(i, 1) = i - 3
Cells(i, 2) = Cells(7, 21)
Cells(i, 3) = Cells(9, 21)
Cells(i, 4) = Cells(11, 21)
Cells(i, 5) = Cells(13, 21)
Cells(i, 6) = Cells(15, 21)
Cells(i, 7) = Cells(17, 21)
Cells(i, 8) = Cells(19, 21)
Cells(i, 9) = Cells(21, 21)
Cells(i, 10) = Cells(23, 21)
Cells(i, 11) = Cells(5, 21)
Cells(i, 12) = Cells(27, 21)
Cells(i, 13) = Cells(25, 21)
End Sub