'Option Explicit
Private Declare PtrSafe Function FindWindowA& Lib "User32" _
(ByVal lpClassName$, ByVal lpWindowName$)
Private Declare PtrSafe Function EnableWindow& Lib "User32" _
(ByVal hWnd&, ByVal bEnable&)
Private Declare PtrSafe Function GetWindowLongA& Lib "User32" _
(ByVal hWnd&, ByVal nIndex&)
Private Declare PtrSafe Function SetWindowLongA& Lib "User32" _
(ByVal hWnd&, ByVal nIndex&, ByVal dwNewLong&)
Private Sub UserForm_Initialize()
Dim i As Integer, image1, image2, image3
With Sheets("Acteurs")
For i = 3 To .Range("A65536").End(xlUp).Row
ComboBox1 = .Range("A" & i)
If ComboBox1.ListIndex = -1 Then ComboBox1.AddItem .Range("A" & i)
Next i
End With
image1 = Chemin & TextBox2.Text & ".gif"
WebBrowser1.Navigate "about:<html><body scroll='no'><IMG WIDTH=" & _
Largeur & " HEIGHT=" & Hauteur & "img src='" & image1 & "'></img></body></html>"
image2 = Chemin & TextBox4.Text & ".gif"
WebBrowser2.Navigate "about:<html><body scroll='no'><IMG WIDTH=" & _
Largeur & " HEIGHT=" & Hauteur & "img src='" & image2 & "'></img></body></html>"
image3 = Chemin & TextBox6.Text & ".gif"
WebBrowser3.Navigate "about:<html><body scroll='no'><IMG WIDTH=" & _
Largeur & " HEIGHT=" & Hauteur & "img src='" & image2 & "'></img></body></html>"
Dim Fichier As String
Dim img As Long
Dim hWnd As Long
Fichier = ThisWorkbook.Path & "\terre.ico"
img = Len(Dir(Fichier))
If img = 0 Then Exit Sub
img = ExtractIconA(0, Fichier, 0)
SendMessageA FindWindow(vbNullString, Me.Caption), &H80, False, img
hWnd = FindWindowA(vbNullString, Me.Caption)
SetWindowLongA hWnd, -16, GetWindowLongA(hWnd, -16) Or &H20000
End Sub
Private Sub UserForm_Activate()
Dim i As Long
Me.ComboBox1 = ""
For i = 1 To 6
Me.Controls("TextBox" & i) = ""
Next i
Me.WebBrowser1.Visible = False
Me.WebBrowser2.Visible = False
Me.WebBrowser3.Visible = False
Dim hWnd As Long
hWnd = FindWindowA("XLMAIN", Application.Caption)
EnableWindow hWnd, 1
End Sub
Private Sub ComboBox1_Change()
Dim cel As Range, i As Long
Dim image1, image2, image3
If ComboBox1 = "" Then
For i = 1 To 6
Me.Controls("TextBox" & i) = ""
Next i
Me.WebBrowser1.Visible = False
Me.WebBrowser2.Visible = False
Me.WebBrowser3.Visible = False
End If
Me.WebBrowser1.Visible = True
Me.WebBrowser2.Visible = True
Me.WebBrowser3.Visible = True
Largeur = WebBrowser1.Width * 100 / 100
Hauteur = WebBrowser1.Height * 100 / 100
Largeur = WebBrowser2.Width * 100 / 100
Hauteur = WebBrowser2.Height * 100 / 100
Largeur = WebBrowser3.Width * 100 / 100
Hauteur = WebBrowser3.Height * 100 / 100
With Sheets("Acteurs").Range("a2:a11")
Set cel = .Find(ComboBox1, , xlValues, xlWhole)
If Not cel Is Nothing Then
TextBox1 = cel.Offset(0, 1)
TextBox2 = cel.Offset(0, 2)
TextBox3 = cel.Offset(0, 3)
TextBox4 = cel.Offset(0, 4)
TextBox5 = cel.Offset(0, 5)
TextBox6 = cel.Offset(0, 6)
End If
End With
image1 = Chemin & TextBox2.Text & ".gif"
image2 = Chemin & TextBox4.Text & ".gif"
image3 = Chemin & TextBox6.Text & ".gif"
On Error Resume Next
If TextBox2 <> "" And TextBox4 <> "" Or WebBrowser2 = WebBrowser1 Then
WebBrowser1.Navigate "about:<html><body scroll='no'><IMG WIDTH=" & _
Largeur & " HEIGHT=" & Hauteur & "img src='" & image1 & "'></img></body></html>"
WebBrowser2.Navigate "about:<html><body scroll='no'><IMG WIDTH=" & _
Largeur & " HEIGHT=" & Hauteur & "img src='" & image2 & "'></img></body></html>"
End If
End Sub
Private Sub CmdOn_Click()
Me.WebBrowser1.Refresh
Me.WebBrowser2.Refresh
Me.WebBrowser3.Refresh
End Sub
Private Sub CmdOff_Click()
Me.WebBrowser1.Stop
Me.WebBrowser2.Stop
Me.WebBrowser3.Stop
End Sub
Private Sub CommandButton1_Click()
Unload Me
End Sub