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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
|
Sub TestLD() Dim lms1 As String, lms2 As String, lms3 As String
Dim i As Integer, derLig As Integer, VilleC As Integer, VilleV As Integer
lms1 = ""
lms2 = ""
lms3 = ""
VilleC = Range("G2")
derLig = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To derLig
VilleV = Range("A" & i).Value
Select Case VilleV
Case 1
If lms1 = "" Then
lms1 = Cells(i, 2).Value
Else
lms1 = lms1 & ", " & Cells(i, 2).Value
End If
Case 2
If lms2 = "" Then
lms2 = Cells(i, 2).Value
Else
lms2 = lms2 & ", " & Cells(i, 2).Value
End If
Case 3
If lms3 = "" Then
lms3 = Cells(i, 2).Value
Else
lms3 = lms3 & ", " & Cells(i, 2).Value
End If
End Select
Next i
Select Case VilleC
Case 1
With Range("H2").Validation
.Delete
.Add xlValidateList, Formula1:=lms1
End With
Case 2
With Range("H2").Validation
.Delete
.Add xlValidateList, Formula1:=lms2
End With
Case 3
With Range("H2").Validation
.Delete
.Add xlValidateList, Formula1:=lms3
End With
End Select
End Sub
Sub UF()
With PI
.TBVille.Text = Cells(Range("I2"), 1).Value
.TBSI.Text = Cells(Range("I2"), 2).Value
.TBSDIS.Text = Cells(Range("I2"), 3).Value
.TBObs.Text = Cells(Range("I2"), 4).Value
.PicPI.Picture = LoadPicture("D:\....\" & .TBSI.Value & ".jpg")
.PicPlan.Picture = LoadPicture("D:\...\" & .TBSI.Value & ".jpg") 'En supposant que ce soient des images elles aussi et qu'elles soient stockées de la même manière que les Images des PI (dans un autre dossier bien sûr) '
.Show
End With
End Sub |
