✅ Download the file | www.exceleinfo....
🏆 Subscribe | goo.gl/M5zNA8
In this Post and video we take up a topic that we touched a few months ago, and it is the theme of Inserting images in Excel using vba macros. On that occasion we had a folder where we had some images and those images were inserted into an Excel file.
However, in that macro we lacked to include a way that the images can be adapted to the size of a cell.
Reading the comments of that video, I noticed that several people were asking me about the inserted images adjusting to the size of a cell. We will pay special attention to Yony García's comment, in which he presents us with a vba code that suited our macro. Such a code is used to give a specific size to a selected image.
In the ExtendedOffice site we find a macro that will help us to adjust the size of a selected image to the size of an Excel cell, however the size is adjusted keeping the aspect ratio, that is, we change the size without losing the appearance .
More examples | www.exceleinfo.com
More examples | blogs.itpro.es/...
Facebook Page | / exceleinfo
Get notificacions on Telegram | t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
addin.exceleinf...
Photo by rawpixel.com on Unsplash
Негізгі бет Insert pictures in Excel and resize to fit cells with vba and macros @EXCELeINFO
Пікірлер: 81