Change image based on combo box selection

RevManager · May 26th 2011

I need a solution in layman's terms!
I have a form with a combo box listing 3 companies. Based on the selection of the combo box, cells are populated with company name, address, phone, etc.
I would like to have the company logo to change based on the selection of the combo box.
Attached is a sample. It contains the combo box and the data to which it references. I have included the logos. I have noted how I would like the page to behave.
This is not the final version, so it can be marked up as much as needed to explain.

Armando Montes · May 26th 2011

Re: Change image based on combo box selection

Maybe this:
http://www.excelforum.com/exce…o-a-drop-down-link-2.html

Windy58 · May 26th 2011

Re: Change image based on combo box selection

Try this link:

http://www.andypope.info/fun/picviewer.htm

Windy

RevManager · May 26th 2011

Re: Change image based on combo box selection

Thanks Windy. I had looked at that page as well and did try to follow the example. But like I said, I need super simple. This example showed me that I'm not asking for too much, but it didn't give me the process I needed. I need step-by-step!

junho lee · May 27th 2011

Re: Change image based on combo box selection

Hi RevManager,
Try the following step.
First, locate picture L5, L6, L7 by company name.
Second, create name 'pic', formula:=INDEX('Group Data Entry'!$L$5:$L$11,'Group Data Entry'!$G$2)
Third, copy any cell followed by paste as 'linked picture' ( home tab - other paste option )
Last, change linked cell reference to 'pic' you named in 'Fomula Bar'.
Regards, junho

Armando Montes · May 27th 2011

Re: Change image based on combo box selection

Here is an explained example:
http://www.freewebs.com/davesexcel/SelectPicGetPrice.xls

**mikerickson** · May 27th 2011

Re: Change image based on combo box selection

You could assign this macro to the DropDown.

Code

Sub DropDown1_Change()
    With ActiveSheet
        .Shapes("Picture 12").Visible = False
        .Shapes("Picture 13").Visible = False
        .Shapes("Picture 14").Visible = False
        Select Case .Shapes("Drop Down 1").ControlFormat.Value
            Case 1
            .Shapes("Picture 14").Visible = True
        Case 2
            .Shapes("Picture 12").Visible = True
        Case 3
            .Shapes("Picture 13").Visible = True
        End Select
    End With
End Sub

Display More

Windy58 · May 27th 2011

Re: Change image based on combo box selection

RevManager

Try this link.

http://www.mcgimpsey.com/excel/lookuppics.html

Contains sample workbook and easy to follow instructions.

Windy

Change image based on combo box selection

Participate now!

Share