ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Upload an image depending on the value of cells (https://www.excelbanter.com/excel-worksheet-functions/451364-upload-image-depending-value-cells.html)

luis vejarano

Upload an image depending on the value of cells
 
good days' group

I would like to help me in this VBA script of Excel.
I have this code is not mine, I found diving from the network, is free is not copyrighted.

Sent them the Zip (upload_image.rar), upload it to my account of Google Drive, the example with the images

https://drive.google.com/open?id=0Bw...3VaNFgxUWs0Y3M

It's how to load an external image depending on the value of a cell that is modified with a drop-down list.
_________________________
Basically what I want to do is:
Add another drop-down list, or multiple lists, in other cells for example: A10, A15, A20, etc.

And they are loaded images to the side of the drop-down lists new, but the position of the images that is varied; i.e., a list will load the image to the right, the following list will load the image to the left, the third loading the image on the right, and so on.

I have tried to repeat the code and change the ranges, but I get an error of repeated value; well, my knowledge of programming in VBA are scarce, but if I understand how to modify the parameters to adapt the codes to my needs..

The code sent to them is the idea that I need, but I want to add more drop-down lists and that the position of the loaded image is varied, not fixed, to be able to adapt it to my needs.

Thank you very much for the help you can give me.

Greetings.

GS[_6_]

Upload an image depending on the value of cells
 
If your dropdowns are in colA then you can't put anything left of there
because A is the leftmost column! Excel will not allow objects to be
placed off the sheet...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

luis vejarano

Upload an image depending on the value of cells
 
Hello Garry , good day, thanks for the clarification.

The drop-down list of the code which send obviously is in cell A1, I don't put it so, you're right that the left does not is may place any image, but the lists that I want to adapt in the first column are not.

Not if you could help me with the script that the list begins, for example, in C1. From already thank you for the help given.

A greeting


All times are GMT +1. The time now is 11:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com