I have a large spreadsheet that has pictures in the comments. I also have a user form that folks use to get quick info by just typing in the part number. The user form returns location, price, yada, yada, yada. But I've also included an image box that I was hoping to get the picture stored as a comment in the spreadsheet to appear in the image box. But I am having no luck at all. I am by no means an expert at code but I have this form working great except for the picture. Any help would be appreciated.
This is the code i have:
Thx
Rick
This is the code i have:
Code:
If Not FindCell Is Nothing Then
Me.TextBox1.Value = FindCell(1, 3).Value
Me.TextBox2.Value = FindCell(1, -1).Value
Me.TextBox3.Value = FindCell(1, 9).Value
Me.TextBox4.Value = FindCell(1, 2).Value
Me.TextBox6.Value = FindCell(1, 6).Value
Me.comentpic1 = FindCell(1, 14).Comment.Shape.fill
Rick