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 34 35 36 37 38 39 40 41 42 43 44 45
| '--- APIs ---
Declare Function FindWindow& Lib "user32.dll" Alias "FindWindowA" ( _
ByVal lpClassName As String, ByVal lpWindowName As String)
Declare Function GetWindowLong& Lib "user32.dll" Alias "GetWindowLongA" ( _
ByVal hwnd As Long, ByVal nIndex As Long)
Declare Function SetWindowLong& Lib "user32.dll" Alias "SetWindowLongA" ( _
ByVal hwnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long)
Declare Function ShowWindow& Lib "user32.dll" ( _
ByVal hwnd As Long, ByVal nCmdShow As Long)
'--- Constante GetWindowLong ---
Const GWL_STYLE As Long = -&H10
'--- Constantes SetWindowLong ---
Const WS_THICKFRAME = &H40000 'Le cadre peut être redimensionné
Const WS_MINIMIZEBOX = &H20000 'Bouton Réduire
Const WS_MAXIMIZEBOX = &H10000 'Bouton Agrandir
Const WS_FRAME_MINI_MAXI = WS_THICKFRAME Or WS_MINIMIZEBOX Or WS_MAXIMIZEBOX 'Fusion des 3 constantes ci-dessus
'--- Constante ShowWindow ---
Const SW_MAXIMIZE As Long = &H3
'--- Variable publique ---
Public USFhwnd&
'#########################
Sub GetHwndUSF(USFCaption As String)
'--- Handle du UserForm ---
USFhwnd& = FindWindow(vbNullString, USFCaption)
End Sub
Sub BoutonsMiniMaxi(Optional dummy As Byte)
'--- Boutons Réduire et Agrandir du UserForm ---
SetWindowLong USFhwnd&, GWL_STYLE, GetWindowLong(USFhwnd&, GWL_STYLE) Xor WS_FRAME_MINI_MAXI
End Sub
Sub USFPleinEcran(Optional dummy As Byte)
'--- Fenêtre du UserForm en plein écran ---
ShowWindow USFhwnd&, SW_MAXIMIZE
End Sub
'########################
'/// votre code ///
Sub saisieclient()
UserForm1.Show
End Sub |
Partager