Load image into image box advice

[ipbr21054]

Afternoon,

Ive got a userform which is working well but struggling to load an image when text boxes are filled with data from combobox selection.
Ive used a code taken from another page but need help please on correctly adding the path to where the images are stored.
This is the path for where the images are.
DESKTOP,REMOTES,LOCK PICKING IMAGES

Now when i make a selection from the combobox not only does the text boxes get entered with the correct data but also an image.

I have supplied the code in use below.

Private Sub ComboBox1_DropButt*******()Dim i As Long, LastRow As Long
LastRow = Sheets("INFO").Range("BC" & Rows.Count).End(xlUp).Row
If Me.ComboBox1.ListCount = 0 Then
For i = 2 To LastRow
Me.ComboBox1.AddItem Sheets("INFO").Cells(i, "BC").Value
Next i
End If
End Sub
Private Sub ComboBox1_Change()
Dim i As Long, LastRow As Long
LastRow = Sheets("INFO").Range("BC" & Rows.Count).End(xlUp).Row
For i = 2 To LastRow
If Sheets("INFO").Cells(i, "BC").Value = (Me.ComboBox1) Or _
Sheets("INFO").Cells(i, "BC").Value = Val(Me.ComboBox1) Then
Me.TextBox1 = Sheets("INFO").Cells(i, "BE").Value
Me.TextBox2 = Sheets("INFO").Cells(i, "BG").Value
Me.TextBox3 = Sheets("INFO").Cells(i, "BI").Value
Me.TextBox4 = Sheets("INFO").Cells(i, "BK").Value
Me.TextBox5 = Sheets("INFO").Cells(i, "BM").Value
Me.TextBox6 = Sheets("INFO").Cells(i, "BO").Value
Me.TextBox7 = Sheets("INFO").Cells(i, "BS").Value
Me.TextBox8 = Sheets("INFO").Cells(i, "BQ").Value
Me.TextBox9 = Sheets("INFO").Cells(i, "BU").Value
End If
Next
End Sub
Private Sub KeyType_Change()
If (Me.TextBox1.Value) = "" Then
   Me.Image1.Picture = LoadPicture(ThisWorkbook.Path & "\dr-logo.jpg")
Else
  Image1.Picture = LoadPicture(ThisWorkbook.Path & "\" & HondaPartNumber.Value & ".jpg")
End If
End Sub

Many thanks

 

[NoSparks]

His post is based on what you indicated in post #5.

It’s location is as follows.
C
Desktop
Remotes
Lock picking images.
Space in between lock picking images

I doubt Desktop is at the root directory level, but if you're not interested in checking, so be it.

 

[ipbr21054]

I’m not at home where the pc is so has nothing to do with not checking it.

I was advising that the _ isnt required.
Some of your replies I don’t like.

 

[NoSparks]

Some of your replies I don’t like.

Rest assured you won't get another.

 

[ipbr21054]

Good