Cells(6,
Cells(l,
Cell(ligne_fin
Cell(6
Cell(ligne_fin + 1
on error goto gestion_erreur
ligne_fin = Cells.Find("*", Range("A1"), , , xlByRows, xlPrevious).Row
je suppose que ton * t'indique la ligne ou tu dois écrire au prochain lancement de ta macro
Cells.Find("*", Range("A1"), , , xlByRows, xlPrevious).Row
et après cela tu dois replacer ton * en=>> Non !
l = ligne_fin + 1
Cell(ligne_fin + 1. )
'Code information du site Sheets("BDD").Cells(l, 1).Value = INB Sheets("BDD").Cells(l, 2).Value = BAT Sheets("BDD").Cells(l, 3).Value = NIV Sheets("BDD").Cells(l, 4).Value = SALLE1 Sheets("BDD").Cells(l, 5).Value = SALLE2 Sheets("BDD").Cells(l, 6).Value = ANFM ' etc...
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionIf CB_nord.Value = True Then 'Si coché ...
Sheets("BDD").Cells(6, 7).Value = "X"
Else 'Si non coché ...
Sheets("BDD").Cells(6, 7).Value = ""
End If
Sheets("BDD").Cells(6, 7).Value = String(CB_nord.Value ^ 2, "X")
Private Sub CommandButton1_Click()
info_gen.Show
End Sub
Private Sub CommandButton3_Click()
Dim observation As String
Dim l As Integer
Dim ligne_fin As Long
ligne_fin = Cells.Find("*", Range("A6"), , , xlByRows, xlPrevious).Row
l = ligne_fin + 1
'Code information du site
Sheets("BDD").Cells(l, 1).Value = TB_inb.Value
Sheets("BDD").Cells(l, 2).Value = TB_bat.Value
Sheets("BDD").Cells(l, 3).Value = TB_niv.Value
Sheets("BDD").Cells(l, 4).Value = TB_salle1.Value
Sheets("BDD").Cells(l, 5).Value = TB_salle2.Value
Sheets("BDD").Cells(l, 6).Value = TB_anfm.Value
'Code orientation du mur
Sheets("BDD").Cells(l, 7).Value = String(CB_nord.Value ^ 2, "X")
Sheets("BDD").Cells(l, 8).Value = String(CB_sud.Value ^ 2, "X")
Sheets("BDD").Cells(l, 9).Value = String(CB_ouest.Value ^ 2, "X")
Sheets("BDD").Cells(l, 10).Value = String(CB_est.Value ^ 2, "X")
'Code localisation du defaut
Sheets("BDD").Cells(l, 11).Value = String(CB_plancher.Value ^ 2, "X")
Sheets("BDD").Cells(l, 12).Value = String(CB_radier.Value ^ 2, "X")
Sheets("BDD").Cells(l, 13).Value = String(CB_plafond.Value ^ 2, "X")
Sheets("BDD").Cells(l, 14).Value = String(CB_poutre.Value ^ 2, "X")
Sheets("BDD").Cells(l, 15).Value = String(CB_poteau.Value ^ 2, "X")
'Code environnement
Sheets("BDD").Cells(l, 16).Value = String(CB_interieur.Value ^ 2, "X")
Sheets("BDD").Cells(l, 17).Value = String(CB_extprotege.Value ^ 2, "X")
Sheets("BDD").Cells(l, 18).Value = String(CB_extnonprotege.Value ^ 2, "X")
'Code accessibilité de la salle
Sheets("BDD").Cells(l, 23).Value = String(CB_salleoui.Value ^ 2, "X")
Sheets("BDD").Cells(l, 24).Value = String(CB_risqueradio.Value ^ 2, "X")
Sheets("BDD").Cells(l, 25).Value = String(CB_trxcours.Value ^ 2, "X")
Sheets("BDD").Cells(l, 26).Value = String(CB_perturbexploit.Value ^ 2, "X")
Sheets("BDD").Cells(l, 27).Value = String(CB_autres.Value ^ 2, "X")
'Code accessibilité de la fissure
Sheets("BDD").Cells(l, 28).Value = String(CB_accfissoui.Value ^ 2, "X")
Sheets("BDD").Cells(l, 29).Value = String(CB_accfisspart.Value ^ 2, "X")
Sheets("BDD").Cells(l, 30).Value = String(CB_accfissnon.Value ^ 2, "X")
Sheets("BDD").Cells(l, 31).Value = String(CB_accfissencomb.Value ^ 2, "X")
Sheets("BDD").Cells(l, 32).Value = String(CB_accfissacces.Value ^ 2, "X")
Sheets("BDD").Cells(l, 33).Value = String(CB_accfissautre.Value ^ 2, "X")
'Code Partie A: apparence béton
'Couleur
Sheets("BDD").Cells(l, 35).Value = String(CB_inco.Value ^ 2, "X")
Sheets("BDD").Cells(l, 36).Value = String(CB_rou.Value ^ 2, "X")
Sheets("BDD").Cells(l, 37).Value = String(CB_blan.Value ^ 2, "X")
'Infiltrations
Sheets("BDD").Cells(l, 38).Value = String(CB_pastrace.Value ^ 2, "X")
Sheets("BDD").Cells(l, 39).Value = String(CB_trace.Value ^ 2, "X")
'Type d'infiltration
Sheets("BDD").Cells(l, 40).Value = String(CB_coulure.Value ^ 2, "X")
Sheets("BDD").Cells(l, 41).Value = String(CB_humide.Value ^ 2, "X")
Sheets("BDD").Cells(l, 42).Value = String(CB_seche.Value ^ 2, "X")
Sheets("BDD").Cells(l, 43).Value = String(CB_efflorescence.Value ^ 2, "X")
Sheets("BDD").Cells(l, 44).Value = String(CB_aureole.Value ^ 2, "X")
'Partie B: Aciers au droit de la fissure
Sheets("BDD").Cells(l, 45).Value = String(CB_tracecorosion.Value ^ 2, "X")
Sheets("BDD").Cells(l, 46).Value = String(CB_pasacier.Value ^ 2, "X")
Sheets("BDD").Cells(l, 47).Value = String(CB_acier.Value ^ 2, "X")
'Partie C: Etat de la surface du béton
'Général
Sheets("BDD").Cells(l, 48).Value = String(CB_bonetat.Value ^ 2, "X")
Sheets("BDD").Cells(l, 49).Value = String(CB_suspect.Value ^ 2, "X")
'Défaut relevés
Sheets("BDD").Cells(l, 50).Value = String(CB_resfiss.Value ^ 2, "X")
Sheets("BDD").Cells(l, 51).Value = String(CB_rsirag.Value ^ 2, "X")
Sheets("BDD").Cells(l, 52).Value = String(CB_ecaillage.Value ^ 2, "X")
Sheets("BDD").Cells(l, 53).Value = String(CB_cloquage.Value ^ 2, "X")
Sheets("BDD").Cells(l, 54).Value = String(CB_epauff.Value ^ 2, "X")
Sheets("BDD").Cells(l, 55).Value = String(CB_autre2.Value ^ 2, "X")
'Commentaire partie C
Sheets("BDD").Cells(l, 56).Value = TB_commEtatSurface.Value
'Localisation de la fissure
'Salle 1
Sheets("BDD").Cells(l, 57).Value = String(CB_zone3R.Value ^ 2, "X")
Sheets("BDD").Cells(l, 58).Value = String(CB_zone4.Value ^ 2, "X")
Sheets("BDD").Cells(l, 59).Value = String(CB_sectfeu.Value ^ 2, "X")
Sheets("BDD").Cells(l, 60).Value = String(CB_paroiext.Value ^ 2, "X")
Sheets("BDD").Cells(l, 61).Value = String(CB_123.Value ^ 2, "X")
'Commentaire
Sheets("BDD").Cells(l, 62).Value = TB_commLocaFiss1.Value
'Salle 2
Sheets("BDD").Cells(l, 63).Value = String(CB2_zone3R.Value ^ 2, "X")
Sheets("BDD").Cells(l, 64).Value = String(CB2_zone4.Value ^ 2, "X")
Sheets("BDD").Cells(l, 65).Value = String(CB2_sectfeu.Value ^ 2, "X")
Sheets("BDD").Cells(l, 66).Value = String(CB2_paroiext.Value ^ 2, "X")
Sheets("BDD").Cells(l, 67).Value = String(CB2_123.Value ^ 2, "X")
'Commentaire
Sheets("BDD").Cells(l, 68).Value = TB_commLocaFiss2.Value
'Attribut fissures :
Sheets("BDD").Cells(l, 69).Value = String(CB_nontrav.Value ^ 2, "X")
Sheets("BDD").Cells(l, 70).Value = String(CB_trav.Value ^ 2, "X")
Sheets("BDD").Cells(l, 71).Value = String(CB_noncaract.Value ^ 2, "X")
Sheets("BDD").Cells(l, 72).Value = String(CB_ecartdixieme.Value ^ 2, "X")
Sheets("BDD").Cells(l, 75).Value = String(CB_inf1mm.Value ^ 2, "X")
Sheets("BDD").Cells(l, 76).Value = String(CB_sup1mm.Value ^ 2, "X")
'ecart min et ecart max
Sheets("BDD").Cells(l, 74).Value = TB_emin.Value
Sheets("BDD").Cells(l, 73).Value = TB_emax.Value
'Observation générales
observation = InputBox("Remarques sur l'inspection:", "Observations génarales")
Sheets("BDD").Cells(l, 77).Value = observation
'Photos
Sheets("BDD").Cells(l, 78).Value = TB_photo1.Value
Sheets("BDD").Cells(l, 79).Value = TB_photo2.Value
Sheets("BDD").Cells(l, 80).Value = TB_photo3.Value
Sheets("BDD").Cells(l, 81).Value = TB_photo4.Value
Sheets("BDD").Cells(l, 82).Value = TB_photo5.Value
l = l + 1
End Sub
ligne_fin = Cells.Find("*", Range("A6"), , , xlByRows, xlPrevious).Row
l = l + 1
Private Sub CommandButton1_Click()
info_gen.Show
End Sub
Private Sub CommandButton3_Click()
Dim observation As String
Dim l As Integer
Dim ligne_fin As Long
ligne_fin = Cells.Find("*", Range("A1"), , , xlByRows, xlPrevious).Row
l = ligne_fin + 1
'Code information du site
Sheets("BDD").Cells(l, 1).Value = TB_inb.Value
Sheets("BDD").Cells(l, 2).Value = TB_bat.Value
Sheets("BDD").Cells(l, 3).Value = TB_niv.Value
Sheets("BDD").Cells(l, 4).Value = TB_salle1.Value
Sheets("BDD").Cells(l, 5).Value = TB_salle2.Value
Sheets("BDD").Cells(l, 6).Value = TB_anfm.Value
'Code orientation du mur
Sheets("BDD").Cells(l, 7).Value = String(CB_nord.Value ^ 2, "X")
Sheets("BDD").Cells(l, 8).Value = String(CB_sud.Value ^ 2, "X")
Sheets("BDD").Cells(l, 9).Value = String(CB_ouest.Value ^ 2, "X")
Sheets("BDD").Cells(l, 10).Value = String(CB_est.Value ^ 2, "X")
'Code localisation du defaut
Sheets("BDD").Cells(l, 11).Value = String(CB_plancher.Value ^ 2, "X")
Sheets("BDD").Cells(l, 12).Value = String(CB_radier.Value ^ 2, "X")
Sheets("BDD").Cells(l, 13).Value = String(CB_plafond.Value ^ 2, "X")
Sheets("BDD").Cells(l, 14).Value = String(CB_poutre.Value ^ 2, "X")
Sheets("BDD").Cells(l, 15).Value = String(CB_poteau.Value ^ 2, "X")
'Code environnement
Sheets("BDD").Cells(l, 16).Value = String(CB_interieur.Value ^ 2, "X")
Sheets("BDD").Cells(l, 17).Value = String(CB_extprotege.Value ^ 2, "X")
Sheets("BDD").Cells(l, 18).Value = String(CB_extnonprotege.Value ^ 2, "X")
'Code accessibilité de la salle
Sheets("BDD").Cells(l, 23).Value = String(CB_salleoui.Value ^ 2, "X")
Sheets("BDD").Cells(l, 24).Value = String(CB_risqueradio.Value ^ 2, "X")
Sheets("BDD").Cells(l, 25).Value = String(CB_trxcours.Value ^ 2, "X")
Sheets("BDD").Cells(l, 26).Value = String(CB_perturbexploit.Value ^ 2, "X")
Sheets("BDD").Cells(l, 27).Value = String(CB_autres.Value ^ 2, "X")
'Code accessibilité de la fissure
Sheets("BDD").Cells(l, 28).Value = String(CB_accfissoui.Value ^ 2, "X")
Sheets("BDD").Cells(l, 29).Value = String(CB_accfisspart.Value ^ 2, "X")
Sheets("BDD").Cells(l, 30).Value = String(CB_accfissnon.Value ^ 2, "X")
Sheets("BDD").Cells(l, 31).Value = String(CB_accfissencomb.Value ^ 2, "X")
Sheets("BDD").Cells(l, 32).Value = String(CB_accfissacces.Value ^ 2, "X")
Sheets("BDD").Cells(l, 33).Value = String(CB_accfissautre.Value ^ 2, "X")
'Code Partie A: apparence béton
'Couleur
Sheets("BDD").Cells(l, 35).Value = String(CB_inco.Value ^ 2, "X")
Sheets("BDD").Cells(l, 36).Value = String(CB_rou.Value ^ 2, "X")
Sheets("BDD").Cells(l, 37).Value = String(CB_blan.Value ^ 2, "X")
'Infiltrations
Sheets("BDD").Cells(l, 38).Value = String(CB_pastrace.Value ^ 2, "X")
Sheets("BDD").Cells(l, 39).Value = String(CB_trace.Value ^ 2, "X")
'Type d'infiltration
Sheets("BDD").Cells(l, 40).Value = String(CB_coulure.Value ^ 2, "X")
Sheets("BDD").Cells(l, 41).Value = String(CB_humide.Value ^ 2, "X")
Sheets("BDD").Cells(l, 42).Value = String(CB_seche.Value ^ 2, "X")
Sheets("BDD").Cells(l, 43).Value = String(CB_efflorescence.Value ^ 2, "X")
Sheets("BDD").Cells(l, 44).Value = String(CB_aureole.Value ^ 2, "X")
'Partie B: Aciers au droit de la fissure
Sheets("BDD").Cells(l, 45).Value = String(CB_tracecorosion.Value ^ 2, "X")
Sheets("BDD").Cells(l, 46).Value = String(CB_pasacier.Value ^ 2, "X")
Sheets("BDD").Cells(l, 47).Value = String(CB_acier.Value ^ 2, "X")
'Partie C: Etat de la surface du béton
'Général
Sheets("BDD").Cells(l, 48).Value = String(CB_bonetat.Value ^ 2, "X")
Sheets("BDD").Cells(l, 49).Value = String(CB_suspect.Value ^ 2, "X")
'Défaut relevés
Sheets("BDD").Cells(l, 50).Value = String(CB_resfiss.Value ^ 2, "X")
Sheets("BDD").Cells(l, 51).Value = String(CB_rsirag.Value ^ 2, "X")
Sheets("BDD").Cells(l, 52).Value = String(CB_ecaillage.Value ^ 2, "X")
Sheets("BDD").Cells(l, 53).Value = String(CB_cloquage.Value ^ 2, "X")
Sheets("BDD").Cells(l, 54).Value = String(CB_epauff.Value ^ 2, "X")
Sheets("BDD").Cells(l, 55).Value = String(CB_autre2.Value ^ 2, "X")
'Commentaire partie C
Sheets("BDD").Cells(l, 56).Value = TB_commEtatSurface.Value
'Localisation de la fissure
'Salle 1
Sheets("BDD").Cells(l, 57).Value = String(CB_zone3R.Value ^ 2, "X")
Sheets("BDD").Cells(l, 58).Value = String(CB_zone4.Value ^ 2, "X")
Sheets("BDD").Cells(l, 59).Value = String(CB_sectfeu.Value ^ 2, "X")
Sheets("BDD").Cells(l, 60).Value = String(CB_paroiext.Value ^ 2, "X")
Sheets("BDD").Cells(l, 61).Value = String(CB_123.Value ^ 2, "X")
'Commentaire
Sheets("BDD").Cells(l, 62).Value = TB_commLocaFiss1.Value
'Salle 2
Sheets("BDD").Cells(l, 63).Value = String(CB2_zone3R.Value ^ 2, "X")
Sheets("BDD").Cells(l, 64).Value = String(CB2_zone4.Value ^ 2, "X")
Sheets("BDD").Cells(l, 65).Value = String(CB2_sectfeu.Value ^ 2, "X")
Sheets("BDD").Cells(l, 66).Value = String(CB2_paroiext.Value ^ 2, "X")
Sheets("BDD").Cells(l, 67).Value = String(CB2_123.Value ^ 2, "X")
'Commentaire
Sheets("BDD").Cells(l, 68).Value = TB_commLocaFiss2.Value
'Attribut fissures :
Sheets("BDD").Cells(l, 69).Value = String(CB_nontrav.Value ^ 2, "X")
Sheets("BDD").Cells(l, 70).Value = String(CB_trav.Value ^ 2, "X")
Sheets("BDD").Cells(l, 71).Value = String(CB_noncaract.Value ^ 2, "X")
Sheets("BDD").Cells(l, 72).Value = String(CB_ecartdixieme.Value ^ 2, "X")
Sheets("BDD").Cells(l, 75).Value = String(CB_inf1mm.Value ^ 2, "X")
Sheets("BDD").Cells(l, 76).Value = String(CB_sup1mm.Value ^ 2, "X")
'ecart min et ecart max
Sheets("BDD").Cells(l, 74).Value = TB_emin.Value
Sheets("BDD").Cells(l, 73).Value = TB_emax.Value
'Observation générales
observation = InputBox("Remarques sur l'inspection:", "Observations génarales")
Sheets("BDD").Cells(l, 77).Value = observation
'Photos
Sheets("BDD").Cells(l, 78).Value = TB_photo1.Value
Sheets("BDD").Cells(l, 79).Value = TB_photo2.Value
Sheets("BDD").Cells(l, 80).Value = TB_photo3.Value
Sheets("BDD").Cells(l, 81).Value = TB_photo4.Value
Sheets("BDD").Cells(l, 82).Value = TB_photo5.Value
End Sub
Je suis interresser, pourriez vous m'en dire plus ? ou j'ouvre un autre poste ?
Private Sub CommandButton3_Click()_________
Static k As Long ' j'ai choisi k plutôt que l car "l" ressemble trop à "1" dans l'éditeur
Dim toto As Control
With Worksheets("BDD")
If k = 0 Then k = .Range("A" & Rows.Count).End(xlUp).Row
k = k + 1
For Each toto In Me.Controls
If toto.Tag <> "" Then
Select Case TypeName(toto)
Case "CheckBox", "OptionButton"
.Range(toto.Tag & k) = String(toto.Value ^ 2, "X")
Case Else
.Range(toto.Tag & k) = toto.Value
End Select
End If
Next
End With
End Sub
_______________
.Range(toto.Tag & k) = toto.Value
Case Else
MsgBox toto.Name
.Range(toto.Tag & k) = toto.Value
End Select
Pour chaque contrôle de ton Userform dont la valeur doit avoir une répercussion sur une cellule de ta feuille Excel