G gopinath1 New Member Mar 6, 2010 #1 I have 10 pictures to be chosen to complete a form in a work sheet; Is there a way to drop list and choose pictures from the list of 10; i am a beginner and would like to avoid VBA.. any help appreciated
I have 10 pictures to be chosen to complete a form in a work sheet; Is there a way to drop list and choose pictures from the list of 10; i am a beginner and would like to avoid VBA.. any help appreciated
A AMG New Member Mar 6, 2010 #2 Havent tried it with pictures but this may give you an idea http://chandoo.org/wp/2009/05/19/dynamic-charts-in-excel/
Havent tried it with pictures but this may give you an idea http://chandoo.org/wp/2009/05/19/dynamic-charts-in-excel/
oldchippy Active Member Mar 6, 2010 #3 Hi, If you would like to see another option but using a little VBA then take a look here http://www.mcgimpsey.com/excel/lookuppics.html
Hi, If you would like to see another option but using a little VBA then take a look here http://www.mcgimpsey.com/excel/lookuppics.html
C Clarity New Member Mar 7, 2010 #4 Hi, There will be a series of posts covering this subject later in the month in the blog area. It does use VBA though I'm afraid. Myles
Hi, There will be a series of posts covering this subject later in the month in the blog area. It does use VBA though I'm afraid. Myles
C Clarity New Member Mar 7, 2010 #5 This post from Chandoo is the best non VBA method that I have seen: http://chandoo.org/wp/2008/11/05/select-show-one-chart-from-many/ Myles
This post from Chandoo is the best non VBA method that I have seen: http://chandoo.org/wp/2008/11/05/select-show-one-chart-from-many/ Myles