Is it possible to show pictures with a combo box instead of using data validation list.
Is it possible to show pictures with a combo box instead of using data validation list.
How are you doing it with data validation right now?Originally Posted by jasdeep
I'm using the method shown in this post http://www.excelforum.com/showthread...hlight=picture at the moment.Originally Posted by davesexcel
Last edited by jasdeep; 03-09-2008 at 06:47 PM.
Hi,Originally Posted by jasdeep
There are 24 posts in that thread, I don't know what you are referring to, but I suppose if you are referring to the vlookup approach, you should still be able to do it, don't know what combo box you are referring to though
Hi there davesexcel, im sorry for being so brief, basically at the moment the steps i have taken are the following:Originally Posted by davesexcel
If you want to avoid the VBA programming approach, try this:
Assumption: Pictures are stored on Sheet2 and will be dynamically shown on Sheet1.
Select Sheet2 and turn off Grid Lines
...<Tools>Options><View tab>Uncheck: Grid Lines
1)For each picture to be displayed:
1a. <Insert><Picture from file> (select picture and put it in the sheet).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by the dropdown list text:
Example for a picture of an Elephant:
<Insert><Name><Define>
Names in Workbook: picElephant
2)Build your data validation list on a cell in Sheet1 and pick one of the items.
3)Create a dynamic range name that refers to that cell:
<Insert><Name><Define>
Names in Workbook: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
...or whatever cell you chose.
4)Copy/Paste one of the pictures from Sheet2 to the display cell on Sheet1.
5)With the picture selected, type this in the formula bar, then press [Enter]:
=ShowMyPic
The picture will be replaced by the picture referred to by the dropdown list.
Each time you select a different item in the list, the associated picture
will appear in the picture box and resize appropriately.
Many thanks to Ron Coderre for posting that method.
So basically instead of using the data validation method for a cell to show the different options i want to use a combo box, the reason why i want to have a combo box is because i need the price for the item being selected in the combo box to change, if you scroll down a little on this website you will see a bunch of combo boxes, notice how the price and image changes as you selected a different item, LINK.
that is basically what i want to achieve.
thanks alot for your help.
Last edited by jasdeep; 03-10-2008 at 07:47 AM.
You can still use the data validation, and use the vlookup to change the prices depending in the selection madeSo basically instead of using the data validation method for a cell to show the different options i want to use a combo box, the reason why i want to have a combo box is because i need the price for the item being selected in the combo box to change, if you scroll down a little on this website you will see a bunch of combo boxes, notice how the price on the left of the item changes as you selected a different item, LINK.
that is basically what i want to achieve.
here's a simple example for vlookup, check out sheet 2 to see the data
http://www.excelforum.com/showthread...76#post1807076
Hi again,Originally Posted by davesexcel
thankyou very much for that example Dave. I am still a little confused, so i just wanted to ask if its not too much could you create what i am looking for, with just one image and price so i can work along with it pleasee. i would be so greatfull. CLICK HERE to show a workbook with the image and price and instructions(in sheet 2)to get you started.
thanks alot. you're a star.
Hi,Originally Posted by jasdeep
the example from the linked thread, really should show you how this can be done, if you need additional help on this, maybe attach a sample workbook with the pics and somebody will be able to help you...
If you are able to select pictures without VBA, this would be a great example for a lot of us......
Hi there dave,Originally Posted by davesexcel
if you click this link it gives an picture and instruction on how to create the drop down picture link, i would give you it with the example done however i do not understand how to do that myself. CLICK HERE.
thanks.
Hi,
Your Link did not work for me so I created my own example,
On sheet 1:
A1 has the drop down menu(using data validation and a named range "List"
H4 Shows the price of the item Selected Using Vlookup function
Sheet 3
There are the pics
and the List of pictures and prices next to them
SelectPicGetPrice 12-Mar-08 19-21-11.zip
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks