Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 2nd 16, 05:36 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2015
Posts: 16
Default 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.

  #2   Report Post  
Old April 2nd 16, 07:23 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,182
Default 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
  #3   Report Post  
Old April 3rd 16, 05:07 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2015
Posts: 16
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional number depending on image name [email protected] Excel Discussion (Misc queries) 0 January 2nd 07 01:07 PM
upload text and/or image files to a web server? Naran Hirani Excel Programming 0 July 28th 03 08:41 PM
upload a button image Oliver Chiu Excel Programming 3 July 17th 03 07:33 PM


All times are GMT +1. The time now is 11:29 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017