show pictures with a combo box

Originally Posted by jasdeep

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 davesexcel

How are you doing it with data validation right now?

I'm using the method shown in this post http://www.excelforum.com/showthread...hlight=picture at the moment.

Originally Posted by jasdeep

I'm using the method shown in this post http://www.excelforum.com/showthread...hlight=picture at the moment.

Hi,
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

Originally Posted by davesexcel

Hi,
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:

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.

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 on the left of the item changes as you selected a different item, LINK.
that is basically what i want to achieve.

You can still use the data validation, and use the vlookup to change the prices depending in the selection made
here's a simple example for vlookup, check out sheet 2 to see the data

http://www.excelforum.com/showthread...76#post1807076

Originally Posted by jasdeep

Hi again,
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,

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,
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