• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Referencing Jpegs within Excel

R

raggd

New Member
Hi Everyone,

First post, but I've followed the forums for a year now and has been extremely useful.

I am currently making a dashboard to show the characteristics of various subsea structures from a database. Thats all fine. I can pick from a drop down list a structure and all the relevant information and graphs flows through.
What I would like to do though is when I pick from this list, a relevant picture of said structure will appear on the dashboard automatically, deleting whatever previous pic was there before.
a) is there any way of doing this?
b) even better is there any way of doing this without VBA macros?
I can have the pictures all in a worsheet tab, or in a separate folder if need be.
 
Hi raggd,

Welcome to chandoo.org forum.

Yes this can be done without using VBA. This forum has such post. Try searching it. If you don't get proper result, write back and we will surely help you with the links.

Regards,
 
Hi Somendra, thank you for your response.
I've managed to do it with VBA fairly easily, but still not managing it without VBA which is desirable (see attached)
This should probable be ok, but if you do know of any non-VBA solutions I'd be interested to know. I didn't find what I was looking for when I searched before.

Regards,
 

Attachments

  • Pic insert VBA.xlsm
    20.7 KB · Views: 4
raggd said:
Hi Somendra, thank you for your response.
I've managed to do it with VBA fairly easily, but still not managing it without VBA which is desirable (see attached)
This should probable be ok, but if you do know of any non-VBA solutions I'd be interested to know. I didn't find what I was looking for when I searched before.

Regards,
Click to expand...
Hi,

The non VBA approach will require all your image on a sheet, so if you can upload a file with say 5 sample image than I can show you how to do it.

Regards,
 
Oh I like that, very elegant. Thank you so much I think this will work perfectly when added into my database.
 
have a look at the Name Manager, in there you'll see the formula that links the data validation to the picture I believe
 
  • Like
Reactions: Aby
@Somendra Misra pls tell me when I try to do this in a new file for another use, I get 0 instead of picture. How did you connect the picture with the cell B#, I even tried insert but it does not work.
 
You must log in or register to reply here.
Back
Top