Bonjour
En modifiant le code de Nad
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim LastRow As Long
Dim Sens As Integer, Col As Integer
If Not Application.Intersect(Target, Range("B3:F3")) Is Nothing Then
Application.ScreenUpdating = False
Col = Target.Column
On Error Resume Next
LastRow = ActiveSheet.Range("B" & Rows.Count).End(xlUp).Row
Sens = xlAscending
If Cells(3, Col) < Cells(LastRow, Col) Then
Sens = xlDescending
End If
Range("B3:F" & LastRow).Sort Key1:=Cells(3, Col), Order1:=Sens, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortTextAsNumbers
End If
End Sub