Hi all, am trying to make a list in excel where once i enter sku of my products it should show the image of that product.
Have managed to get the macro for one button but next to it want to put another button macro where i punch in the sku and it will show the image.

I tried copying the same macro to the second button, but it deletes my image which i got from my first macro.
I want the same the macro to work for my second macro without deleting what i got in my first macro.

Sub SearchDesign1()
Application.ScreenUpdating = False
Dim myObj
Dim Pictur
Set myObj = ActiveSheet.DrawingObjects
For Each Pictur In myObj
If Left(Pictur.Name, 7) = "Picture" Then
Pictur.Select
Pictur.Delete
End If
Next

Dim DesignName As String, T As String

myDir = "C:\Users\user\Desktop\scan copy\Org Pages\"
DesignName = Range("C2")
T = ".jpg"
On Error GoTo errormessage:
ActiveSheet.Shapes.AddPicture Filename:=myDir & DesignName & T, linktofile:=msoFalse, savewithdocument:=msoTrue, Left:=26, Top:=46, Width:=201, Height:=201
errormessage:
If Err.Number = 1004 Then
MsgBox "File does not exist." & vbCrLf & "Check the name of the Design!"
Range("C2").Value = ""

End If
Application.ScreenUpdating = True
End Sub
Regards

Nirmall