Top and Left properties for images

[zirus]

Hi

How do I arrange my syntax so that vba can check if an image has a left setting of x and a top setting of y....
can this be done?

thanx in advance

[Simon Lloyd]

I have no idea what the title of your post means IF but why dont you record a macro while adding an image and then look at the settings for that, should give you some idea.

Regards,
Simon

[malik641]

Here's another way to access your images if it's embedded:


With Sheets("Sheet1").OLEObjects("ObjectName")
Debug.Print .Top
Debug.Print .Left
End With


Otherwise you should/could use the Shapes collection:


With Sheets("Sheet1").Shapes("ImageName")
Debug.Print .Top
Debug.Print .Left
End With

HTH

[malik641]

Hey zirus,

Welcome! :hi: (sorry didn't mention that in my earlier post)

Just so you know I changed your thread title to better suit your question. Please be sure next time to write a more meaningful title for your questions so more people are willing to look at them.

Thanks and I hope you enjoy the forum :)
Joseph