Murid Picture 6Murid6

VBA yang digunakan

B2 Pakai validation data LIST dengan rumus =OFFSET(PicTable,,,,1)

Kita menggunakan Vlookup untuk di F1 dengan rumus =VLOOKUP(A2, PicTable, 2, FALSE)

Untuk memasukan foto sesuai dengan urutan picture mulai dari no 1 sampai dengan 109

yang sudah dimasukkan murid sampai dengan murid ke 8. kalau mau merubah tinggal kliik kanan change picture

Private Sub Worksheet_Calculate() Dim oPic As Picture Me.Pictures.Visible = False With Range("F1") For Each oPic In Me.Pictures If oPic.Name = .Text Then oPic.Visible = True oPic.Top = .Top oPic.Left = .Left Exit For End If Next oPic End With End Sub

B2 Pakai validation data LIST dengan rumus =OFFSET(PicTable,,,,1)

Private Sub Worksheet_Calculate() Dim oPic As Picture Me.Pictures.Visible = False With Range("F1") For Each oPic In Me.Pictures If oPic.Name = .Text Then oPic.Visible = True oPic.Top = .Top oPic.Left = .Left Exit For End If Next oPic End With End Sub

Name Picture NameMurid1 Picture 1Murid2 Picture 2Murid3 Picture 3Murid4 Picture 4Murid5 Picture 5Murid6 Picture 6Murid7 Picture 7Murid8 Picture 8Murid9 Picture 9

Murid10 Picture 10Murid11 Picture 11Murid12 Picture 12Murid13 Picture 13Murid14 Picture 14Murid15 Picture 15Murid16 Picture 16Murid17 Picture 17Murid18 Picture 18Murid19 Picture 19Murid20 Picture 20Murid21 Picture 21Murid22 Picture 22Murid23 Picture 23Murid24 Picture 24Murid25 Picture 25Murid26 Picture 26Murid27 Picture 27Murid28 Picture 28Murid29 Picture 29Murid30 Picture 30Murid31 Picture 31Murid32 Picture 32Murid33 Picture 33Murid34 Picture 34Murid35 Picture 35Murid36 Picture 36Murid37 Picture 37Murid38 Picture 38Murid39 Picture 39Murid40 Picture 40Murid41 Picture 41Murid42 Picture 42Murid43 Picture 43Murid44 Picture 44Murid45 Picture 45Murid46 Picture 46Murid47 Picture 47Murid48 Picture 48Murid49 Picture 49Murid50 Picture 50Murid51 Picture 51Murid52 Picture 52Murid53 Picture 53

Murid54 Picture 54Murid55 Picture 55Murid56 Picture 56Murid57 Picture 57Murid58 Picture 58Murid59 Picture 59Murid60 Picture 60Murid61 Picture 61Murid62 Picture 62Murid63 Picture 63Murid64 Picture 64Murid65 Picture 65Murid66 Picture 66Murid67 Picture 67Murid68 Picture 68Murid69 Picture 69Murid70 Picture 70Murid71 Picture 71Murid72 Picture 72Murid73 Picture 73Murid74 Picture 74Murid75 Picture 75Murid76 Picture 76Murid77 Picture 77Murid78 Picture 78Murid79 Picture 79Murid80 Picture 80Murid81 Picture 81Murid82 Picture 82Murid83 Picture 83Murid84 Picture 84Murid85 Picture 85Murid86 Picture 86Murid87 Picture 87Murid88 Picture 88Murid89 Picture 89Murid90 Picture 90Murid91 Picture 91Murid92 Picture 92Murid93 Picture 93Murid94 Picture 94Murid95 Picture 95Murid96 Picture 96Murid97 Picture 97Murid98 Picture 98Murid99 Picture 99

Murid100 Picture 100Murid101 Picture 101Murid102 Picture 102Murid103 Picture 103Murid104 Picture 104Murid105 Picture 105Murid106 Picture 106Murid107 Picture 107

Murid108 Picture 108Murid109 Picture 109