How to use VBA code to get image dimensions of inserted images
Requirement:
The user inserts images into excel and saves the excel sheet then shares it with others by sending them via email. At this point the user only need to send the excel sheet which already have the images embedded and save in it.
What the user is trying to do is get the size as width and height in cm for those images and insert them into the cells. A sample sheet can be found on the link below:
Solution:
Obtained from the OzGrid Help Forum.
Solution provided by Carim.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to create a macro that copies all of the tables and charts on a sheet and pastes them as an image on to another sheet |
| How to populate image control from pics in the sheet |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
