Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Integer, ByVal lParam As Any) As Long
End Sub
Public Sub ProgressSetColor(lProgressBarHwnd As Long, lColour As Long, bForeground As Boolean)
Const WM_USER = &H400, CCM_FIRST As Long = &H2000&
Const CCM_SETBKCOLOR As Long = (CCM_FIRST + 1), PBM_SETBKCOLOR As Long = CCM_SETBKCOLOR
Const PBM_SETBARCOLOR As Long = (WM_USER + 9)
On Error GoTo ErrFailed
If bForeground Then
Call SendMessage(lProgressBarHwnd, PBM_SETBARCOLOR, 0&, ByVal lColour)
Else
Call SendMessage(lProgressBarHwnd, PBM_SETBKCOLOR, 0&, ByVal lColour)
End If
Exit Sub
ErrFailed:
Debug.Print "Error in ProgressSetColor: " & Err.Description
Debug.Assert False
End Sub