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
| Option Explicit
Public Cell As Range
Public Unique, Tbl, i As Long
Public Valeur, LCherche As String
Public Dercel As Range
Sub afficheacces()
With Ficheaccès
.Show
With Sheets("BDD")
Set Cell = .Range("A1", .Range("A" & .Rows.Count).End(xlUp)).Find(LCherche)
End With
If Not Cell Is Nothing Then
.Label12.Caption = Cell
.Label14.Caption = Cell(1, 4)
.Label15.Caption = Cell(1, 6)
.Label17.Caption = Cell(1, 5)
.Label17.Caption = Cell(1, 3)
.Label19.Caption = Cell(1, 8)
.Label20.Caption = Cell(1, 9)
.Label21.Caption = Cell(1, 10)
.Label22.Caption = Cell(1, 11)
.Label23.Caption = Cell(1, 12)
'ci-dessous, je ne prends pas en compte les photos, elles n'existent pas
'.Label24.Picture = Cell(1, 13)
'.Label25.Picture = Cell(1, 14)
'.Label26.Picture = Cell(1, 15)
'.Label27.Picture = Cell(1, 16)
End If
End With
End Sub |
Partager