Trying to Add three pictures to a defined cell

[carrguy01]

I am not sure if i even got the right area on here yet! I am new but I am a quick learner so bear with me. I want to make a feature sheet that I will be changing on a regular basis. I want two different pictures to be located in the top right and top left of my page. The size of the original pictures very. So I need something that will resize them to make it uniformed. They can be in one cell or even merged cells that part does not bother me. The picture size has to be the same I am looking for 1.5 inch by 1.5 inch. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I then want to put a picture of a house that will be changing all the time but the size I want to remain the same and that is 4 inch wide 2 inch tall. <o></o>
<o> </o>
Any help would be great. I am not sure if I need to put my email or not but here it is markcarr01@sympatico.ca<o></o>
<o></o>

 

[VoG]

Maybe like this

With ActiveSheet.Shapes(ActiveSheet.Shapes.Count)
    .LockAspectRatio = False
    .Top = Range("C3").Top
    .Left = Range("C3").Left
    .Height = Range("C3").RowHeight * 5
    .Width = Range("C3").Width * 2
End With

 

[carrguy01]

can i add a browse button on sheet 3 where all the information is being manually inputer on. I want to use the button to locate and click on the picture and the path be copied and inserted into the code that i have working on sheet 4?

 

[carrguy01]

noy sure that is going to help adding a browse button!! but it is great for the picture sizing!!!