View Full Version : [SLEEPER:] Top and Left properties for images
zirus
12-04-2006, 08:47 AM
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
12-04-2006, 10:12 AM
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
12-04-2006, 11:17 AM
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
12-04-2006, 11:27 AM
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.