ik heb een userform en gebruik deze codes
For l = 0 To ListBox_Results.ListCount
If ListBox_Results.Selected(l) = True Then
strAddress = ListBox_Results.List(l, 1)
strSheet = Replace(Mid(strAddress, 1, InStr(1, strAddress, "!") - 1), "'", "")
Worksheets(strSheet).Select
Worksheets(strSheet).Range(strAddress).Select
With ActiveSheet
f_FindAll.TextBox1.Value = .Cells(.Range(strAddress).Row, 1).Value
f_FindAll.TextBox_Results1.Value = .Cells(.Range(strAddress).Row, 2).Value
f_FindAll.TextBox_Results2.Value = .Cells(.Range(strAddress).Row, 3).Value
f_FindAll.TextBox2.Value = .Cells(.Range(strAddress).Row, 4).Value
f_FindAll.TextBox3.Value = .Cells(.Range(strAddress).Row, 5).Value
f_FindAll.TextBox4.Value = .Cells(.Range(strAddress).Row, 6).Value
f_FindAll.TextBox5.Value = .Cells(.Range(strAddress).Row, 7).Value
f_FindAll.TextBox6.Value = .Cells(.Range(strAddress).Row,
.Value
f_FindAll.TextBox7.Value = .Cells(.Range(strAddress).Row, 9).Value
f_FindAll.TextBox8.Value = .Cells(.Range(strAddress).Row, 10).Value
End With
GoTo EndLoop
End If
f_FindAll.TextBox8.Value = .Cells(.Range(strAddress).Row, 10).Value roep de inhoud van de tekst op die in de Row voorkomt
mijn vraag is kan je ook een jpg oproep in de betreffende row? ipv tekst