Forum Discussion

WLLIAN's avatar
WLLIAN
Brass Contributor
Dec 27, 2023

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...
excel
Formulas and Functions
Macros and VBA
office 365
WLLIAN's avatar
WLLIAN
Brass Contributor
Dec 28, 2023

Patrick2788 

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:

Patrick2788's avatar
Patrick2788
Silver Contributor
Dec 28, 2023

WLLIAN 

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.

  • WLLIAN's avatar
    WLLIAN
    Brass Contributor
    Dec 28, 2023

    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

Resources