Ridurre a icona



  • Ridurre a icona
    di rotella data: 16/02/2014 20:56:00

    Ciao a Tutti,
    come si può inserire in una userform il trattino che riduce ad icona grazie.



  • di Vecchio Frac data: 16/02/2014 21:12:11

    Questa è una buona domanda.
    Riporto il codice prodotto da Mauro Gamberini in un suo articolo su Answer Microsoft: "Excel - Modificare la visualizzazione di una UserForm - VBA".
    Va preso così com'è e utilizzato direttamente nel codice del tuo form.
     
    Option Explicit
    
    #If Win64 Then
    
        Private Declare PtrSafe Function FindWindow& Lib "USER32" _
            Alias "FindWindowA" (ByVal lpClassName As String, _
            ByVal lpWindowName As String)
        
        Private Declare PtrSafe Function SetWindowLong& Lib "USER32" Alias _
            "SetWindowLongA" (ByVal hWnd&, ByVal nIndex&, _
            ByVal dwNewLong As LongLong)
        
        Private Declare PtrSafe Function EnableWindow& Lib "USER32" _
            (ByVal hWnd As LongLong, ByVal fEnable As LongLong)
        
        Private Declare PtrSafe Function ShowWindow& Lib "USER32" _
            (ByVal hWnd As LongLong, ByVal nCmdShow As LongLong)
    
    #Else
    
        Private Declare Function FindWindow& Lib "user32" _
            Alias "FindWindowA" (ByVal lpClassName As String, _
            ByVal lpWindowName As String)
        
        Private Declare Function SetWindowLong& Lib "user32" Alias _
            "SetWindowLongA" (ByVal hWnd As Long, ByVal nIndex As Long, _
            ByVal dwNewLong As Long)
        
        Private Declare Function EnableWindow& Lib "user32" _
            (ByVal hWnd As Long, ByVal fEnable As Long)
        
        Private Declare Function ShowWindow& Lib "user32" _
            (ByVal hWnd As Long, ByVal nCmdShow As Long)
        
    #End If
    
    Private Sub UserForm_Initialize()
    
        Dim lStyle As Long
    
        lStyle = &H84C80080 Or _
            &H20000 Or &H40000
        SetWindowLong FindWindow( _
            vbNullString, Me.Caption), -16, lStyle
        EnableWindow FindWindow( _
            vbNullString, Application.Caption), 1
    
    End Sub
    






  • di rotella data: 17/02/2014 21:14:24

    Grazie 1000 funziona bene!!!!!