1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Option Explicit
Dim ListeDates As Range
Private Sub CommandButton1_Click()
ListeDates.EntireColumn.Hidden = True
Worksheets("Feuil1").Columns(ComboBox1.ListIndex + 1).Resize(, 28).Hidden = False
Worksheets("Feuil1").Cells(1, ComboBox1.ListIndex + 1).Select
Me.Hide
End Sub
Private Sub UserForm_Initialize()
Dim Cel As Range
With Worksheets("Feuil1")
.Columns.Hidden = False
Set ListeDates = .Range(.Cells(1, 1), .Cells(1, Columns.Count).End(xlToLeft))
For Each Cel In ListeDates
ComboBox1.AddItem Format(Cel, "dd/mm/yyyy")
Next Cel
End With
End Sub |
Partager