'Const PictDir As String = "C:\Users\Vermonden\Pictures\DIEREN\"
PictDir = Range("FOTO_MAP").Value
Private Sub Image1_BeforeDragOver(ByVal Cancel As MSForms.ReturnBoolean, ByVal Data As MSForms.DataObject, ByVal X As Single, ByVal Y As Single, ByVal DragState As MSForms.fmDragState, ByVal Effect As MSForms.ReturnEffect, ByVal Shift As Integer)
End Sub
Private Sub Worksheet_Activate()
Image1.Picture = LoadPicture(PictDir & "Geen_Foto.jpg")
Image2.Picture = LoadPicture(PictDir & "Geen_Foto.jpg")
Image3.Picture = LoadPicture(PictDir & "Geen_Foto.jpg")
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$2" Then
If Not Dir(PictDir & Target & ".jpg") = vbNullString Then
With Image1
.Picture = LoadPicture(PictDir & Target & ".jpg")
.PictureSizeMode = 3
With .ShapeRange
.Height = 123.9307
.Width = 205
End With
End With
Else
Image1.Picture = LoadPicture(PictDir & "Geen_Foto.jpg")
End If
If Not Dir(PictDir & Range("F9").Value & ".jpg") = vbNullString Then
With Image2
.Picture = LoadPicture(PictDir & Range("F9").Value & ".jpg")
.PictureSizeMode = 3
With .ShapeRange
.Height = 90.681
.Width = 150
End With
End With
Else
Image2.Picture = LoadPicture(PictDir & "Geen_Foto.jpg")
End If
If Not Dir(PictDir & Range("F25").Value & ".jpg") = vbNullString Then
With Image3
.Picture = LoadPicture(PictDir & Range("F25").Value & ".jpg")
.PictureSizeMode = 3
With .ShapeRange
.Height = 90
.Width = 150
End With
End With
Else
Image3.Picture = LoadPicture(PictDir & "Geen_Foto.jpg")
End If
End If
Application.ScreenUpdating = False
KolommenZichtbaar
If Range("GENERATIES").Value = 2 Then Columns("I:N").Hidden = True
If Range("GENERATIES").Value = 3 Then Columns("K:N").Hidden = True
If Range("GENERATIES").Value = 4 Then Columns("M:N").Hidden = True
Application.ScreenUpdating = True
End Sub
Sub KolommenZichtbaar()
Columns.Hidden = False
End Sub