+ Reply to Thread
Results 1 to 10 of 10

Multiple Drop-Downs and Different Images

  1. #1
    Registered User
    Join Date
    05-21-2020
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    10

    Multiple Drop-Downs and Different Images

    Hi,

    I need a way that when I select a value from a drop down list a picture will generate in the cell below based on the answer.

    I understand how to do this part but my problem is I need it to happen in around 2-300 columns.

    I have a sample attached but when i click the option it changes the images in all columns instead of just the column i want.

    So in my example if I change A2 I want the image in A3 to change but nothing happen in B. Then when i change the image in B2, B3 will change and Column A will be unaffected.

    Is there a way to fix this?

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Multiple Drop-Downs and Different Images

    Well I don't see how you did it in the first place, not macro's?
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    05-21-2020
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    10

    Re: Multiple Drop-Downs and Different Images

    Hi,

    I got the first part from googling but cant find the answer to my questions anywhere. Hopefully it can be done

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,365

    Re: Multiple Drop-Downs and Different Images

    Hans - look at the Named Ranges dialog.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Multiple Drop-Downs and Different Images

    okay, but the index is entirely off that's why and the op changed the sheet names. no go for me
    Last edited by Keebellah; 05-26-2020 at 04:02 AM.

  6. #6
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Multiple Drop-Downs and Different Images

    200 - 300 drop downs
    give the attached a try - a few lines of code - one dropdown arrives where you want it.
    click in the range B2:I2 (this can be extended as far as you wish).
    torachan.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    05-21-2020
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    10

    Re: Multiple Drop-Downs and Different Images

    Hi Torachan,

    Thanks for that it is nearly want I'm looking for. However you made a pop out box to select the options i would need it to be a drop down as there is other drop down that would depend off this selection.

  8. #8
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Multiple Drop-Downs and Different Images

    I think a more detailed/comprehensive list of your requirements would be in order.
    Gluing a project together piece by piece lands up as a 'patchwork quilt'.
    The mere thought of 200-300 drop-downs now followed by even more is not a task to be contemplated.
    Describe the full requirement - there has to be a simpler solution.
    torachan.

  9. #9
    Registered User
    Join Date
    05-21-2020
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    10

    Re: Multiple Drop-Downs and Different Images

    Sorry I might not of explained properly.

    Bascially I'm trying to build an order sheet.

    So in one column will be one order for one door where i have a number of dropdowns.

    Some dropdowns are dependent on other dropdowns.

    So in the attachment I had. When someone selects Door Type 1 I would like that picture to show up and then further down the sheet there are dependent dropdowns based off the Door Type 1 selection.

    But if someone is ordering 200 doors. Then each Column would be different for each door. So i need the pictures to be different.

    If it matters there are only 20 different door types they can select.

    So when i said 2-300 drop downs I mean the drop down for the Door Type could be going across that many columns depending on the order size

    Hope that explains it a bit better

  10. #10
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Multiple Drop-Downs and Different Images

    Why don't you just attach a sample file.
    Why are the doors in the file, you could also have an image folder with all the door images (named correctly) and you could link it to those so you don't create a large Excel file due to embedded images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Creating multiple drop-downs based on primary drop-down selected
    By dcwan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-30-2020, 06:13 PM
  2. Please help! multiple drop downs dependent on first
    By D8THSTAR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-23-2018, 02:49 PM
  3. Multiple Drop Downs
    By wil79 in forum Excel General
    Replies: 3
    Last Post: 12-11-2017, 10:47 AM
  4. [SOLVED] Multiple drop downs
    By Treecko in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-30-2013, 07:24 PM
  5. Multiple drop dependant drop downs in single cell
    By LittleJerry in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2012, 02:21 PM
  6. Multiple dependant drop downs
    By paconovellino in forum Excel General
    Replies: 11
    Last Post: 05-02-2012, 05:05 PM
  7. Multiple Drop-Downs used as parameters for VLOOKUP
    By JPCrow in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-01-2008, 11:53 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1