Private Declare Function SendMessageLong Lib "user32" Alias "SendMessageA"(ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, ByVal lParamAs Long) As LongConst LVM_SETCOLUMNWIDTH = &H1000 + 30Const LVSCW_AUTOSIZE = -1Const LVSCW_AUTOSIZE_USEHEADER = -2' Adjust the width of a ListView control so that each item is fully visibleif second' argument is True, column headers' width is also taken into account.Sub ListViewAdjustColumnWidth(LV As ListView, Optional AccountForHeaders AsBoolean)    Dim col As Integer, lParam As Long    If AccountForHeaders Then        lParam = LVSCW_AUTOSIZE_USEHEADER    Else        lParam = LVSCW_AUTOSIZE    End If    For col = 0 To LV.ColumnHeaders.Count - 1        SendMessageLong LV.hwnd, LVM_SETCOLUMNWIDTH, col, lParam    NextEnd Sub