Inserting Picture in Excel

[Kingfysh]

I know this is mentioned in other posts, but we (my office) can't seem to make it work. We are trying to create a form that will allow us to insert four pictures into excel through the use of a button on the spreadsheet. None of us are well versed at writing code within Excel, but we have been able to get to the developer mode and give it a shot. Can somebody help?

 

[Marc]

You could assign the code below to a button. You would just need to change the code to point to your pictures.


Sub Macro1()

Range("A1").Select
ActiveSheet.Pictures.Insert("H:\Picture1.jpg").Select

Range("A11").Select
ActiveSheet.Pictures.Insert("H:\Picture2.jpg").Select

Range("A21").Select
ActiveSheet.Pictures.Insert("H:\Picture3.jpg").Select

Range("A31").Select
ActiveSheet.Pictures.Insert("H:\Picture4.jpg").Select

End Sub