Forum Discussion
EXCEL - IMAGE ACTIVE CELL
Hi, there a way to pull images from another worksheet? I use this code, but only active by a folder. He create a shape Image beside the active cell. Lets say you have to send to someone, but the p...
If you're in a fully updated Excel 365, there's no need to use code because the version supports 'place in cell' for pictures.
It's easy to set up. Even if you have a folder with multiple images. When you insert the pictures Excel will place them vertically in the column, 1 picture in 1 cell as far as needed.
You could start by setting up a sheet with the pictures like this:
Next, you setup a sheet with the input cells as such (Your arrangement may be different, but you get the idea):
This gif shows what it looks like in motion:
No my friend. This is not what i want. But thank you.
If you see the video, the Image is a Shape that pops up when target a cell, erase the shape when change to another target name and erase when the cell is blank.
The Shape always stay beside the cursor
I dont want vlookup or Function Image kkkk.
Thank you for your time my dear friend.
Exemplo what i want to do:
- https://m.toutiao.com/article/7317779366447153699/?tt_from=copy_link&utm_campaign=client_share&enter_from=click_creation_center&gd_ext_json=%7B%22enter_from%22%3A%22click_creation_center%22%2C%22category_name%22%3A%22creation_center%22%7D&utm_source=copy_link&utm_medium=toutiao_android&share_token=796f12f4-479e-4cf5-b656-6e2726c136f9&category_name=creation_center
videoļ¼
https://m.bilibili.com/video/BV1kt4y1f7XE?buvid=XX85E838539534AD650323D79CEE8DA100517&from_spmid=default-value&is_story_h5=false&mid=FSMZLyVVbtrPTKay0%2Fc9Fg%3D%3D&p=1&plat_id=116&share_from=ugc&share_medium=android&share_plat=android&share_session_id=a1cb7e42-b66d-4c68-83d6-dfacb0430ed7&share_source=COPY&share_tag=s_i&spmid=main.ugc-video-detail.0.0×tamp=1703803765&unique_k=gfHQpEU&up_id=634143044&share_times=1 Why use a shape when the image can be placed in cell? Looks like a difference in philosophy. I try to avoid using code if at all possible. It introduces a security element and things can get messy if others need to access the workbook.
Patrick2788Hi. Put a image into a cell make the row change the size.
I like this way, i think is dynamic. Cool. Something different, impress... you see.Let say you have to send a file to your boss and 10 person send that medium file, basic... and you send a new way of see that file or even to others see.
Most people dont know what excel is able to do.
I love excel and yes i have another files that i use image with vlookup or Objet with image, very simples but i love.
I just wish to make that projet, i love learn excel a little bit every day.
Its a taste thing, everyone like their own way to make spreadsheets kkkk
