jpg to be used as an active x control

[ipbr21054]

I would like to use a jpg image on my worksheet as i dont see any option in the insert Active x control box.
I have placed the images on my worksheet,copied the code from an existing active x control then assigned it etc to my image,saved.

I was assuming that when i press this image the code would run but nothing.

The same code works fine on the source it was copied from.
Is this possible or did i do something wrong ?

Private Sub CommandButton1_Click()
UserForm1.Show
End Sub

Private Sub CommandButton2_Click()
Rows("6:6").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Range("M6").Formula = "=TODAY()"
Range("A6").Select
End Sub

Private Sub Worksheet_Activate()
UserForm1.Show
Range("A6").Select

End Sub

 

[Scott Huish]

An Image is not a Command Button. If you insert the ActiveX Image control, there is an Image Click event. Which the easiest way to get to is to right click on the Image Control and click on View Code. You can also set the image for the control here in the Picture property.

 

[ipbr21054]

All sorted.
I had the incorrect name for each file in the properties box.