La taille des objets dans le formulaire s'adapte en
fonction du paramètre ZOOM compris entre 10 et 400...
Voici le Code du module :
'3 lignes de fonction pour la gestion du PLEIN ECRAN
Private Declare Function FindWindowA Lib "User32" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare Function GetWindowLongA Lib "User32" (ByVal hWnd As Long, ByVal nIndex As Long) As Long
Private Declare Function SetWindowLongA Lib "User32" (ByVal hWnd As Long, ByVal nIndex As Long, ByVal dwNewLong As Long) As Long
Private Sub UserForm_Initialize()
'PLEIN ECRAN
'Changer dans les propriétés du UserForm les options dans Position ;
'Left = 0
'StartUpPosition = 3-Windows Default
'Top = 0
Dim hWnd As Long, exLong As Long, zFactor As Integer
hWnd = FindWindowA(vbNullString, Me.Caption)
exLong = GetWindowLongA(hWnd, -16)
If exLong And &H880000 Then SetWindowLongA hWnd, -16, exLong And -8912897
zFactor = 100 * CInt(Application.Width / Me.Width)
'EXCEL accepte un zoom maxi à 400
If zFactor > 400 Then zFactor = 400
Me.Width = Application.Width
Me.Height = Application.Height
Me.Zoom = zFactor
'PLEIN ECRAN OK
End Sub