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
|
Option Explicit
Private Sub Cbx_champs_Change()
Dim montablo As ListObject
Set montablo = Range("T_Famille").ListObject
With montablo
ReDim T(1 To .ListRows.Count)
T = .ListColumns(Cbx_champs.Value).DataBodyRange.Value
End With
With Sht_Utilitaires.ListObjects("T_Choix")
.AutoFilter.ShowAllData
If Not .DataBodyRange Is Nothing Then .DataBodyRange.Delete
.ListRows.Add
.DataBodyRange.Cells(1, 1).Resize(UBound(T, 1), 1).Value = T
.Range.RemoveDuplicates Columns:=1, Header:=xlYes
With .Sort
.SortFields.Clear
.SortFields.Add Key:=Range("T_Choix").ListObject.ListColumns(1).DataBodyRange, SortOn:=xlSortOnValues, Order:=xlAscending
.Apply
End With
Me.Cbx_records.List = .ListColumns(1).DataBodyRange.Value
End With
Erase T
End Sub |
Partager