Bonjour
J'ai ce code qui m'avait été fourni et que j'ai remanié
Option Explicit
Private Sub UserForm_Initialize()
Dim chn$, dlg As Byte, i As Byte: chn = "Paramètres"
With Worksheets(chn)
Lib01 = .[Y2]: chn = chn & "!": dlg = .Cells(Rows.Count, 1).End(3).Row
For i = 2 To 9
Controls("Lib0" & i).RowSource = "=" & chn & "Y3:Y13" & dlg
Next i
End With
End Sub
Private Sub Lib01_Change(): [B83] = Lib01: End Sub
Private Sub Lib02_Change(): [B84] = Lib02: End Sub
Private Sub Lib03_Change(): [B85] = Lib03: End Sub
Private Sub Lib04_Change(): [B86] = Lib04: End Sub
Private Sub Lib05_Change(): [B87] = Lib05: End Sub
Private Sub Lib06_Change(): [B88] = Lib06: End Sub
Private Sub Lib07_Change(): [B89] = Lib07: End Sub
Private Sub Lib08_Change(): [B90] = Lib08: End Sub
Private Sub Lib09_Change(): [B91] = Lib09: End Sub
Private Sub Lib11_Change(): [B94] = Lib11: End Sub
Private Sub Lib12_Change(): [B95] = Lib12: End Sub
Le userfom s'affiche via le bouton Feuil1
Il va chercher les données en feuille paramètre Y2 à Y13
Ca fonctionne mais mes trois menu déroulant du coté droit Sommes nettes ne fonctionne pas. Une idée ?