+ Reply to Thread
Results 1 to 6 of 6

hide/unhide picutres based on combobox selection

  1. #1
    Registered User
    Join Date
    03-19-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    48

    hide/unhide picutres based on combobox selection

    Hi all - I have seen variations of this code online, but nothing that can do exactly this. I am not even sure if this is possible as all the closest i could find required links to pictures sourced from a folder on the PC.

    I have attached a file. The intention is to select a fruit from the drop down and that picture only to remain visible, while all others hide.

    Thank you for taking the time to look through my request.
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: hide/unhide picutres based on combobox selection

    Take a look at this ...
    5 easy steps for dynamic images
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    03-19-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: hide/unhide picutres based on combobox selection

    Thanks Jeffrey - will check to see if this will do it. really appreciate the help!

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: hide/unhide picutres based on combobox selection

    You are very welcome...

    Another option >> https://www.excelforum.com/excel-gen...ell-value.html

  5. #5
    Registered User
    Join Date
    03-19-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: hide/unhide picutres based on combobox selection

    Thanks again for the link, I strangely couldnt get either to work as needed. Is there an expansion on code similar to the below that could hide and unhide?

    ActiveSheet.Pictures("Banana").Visible = True

  6. #6
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: hide/unhide picutres based on combobox selection

    here is something.

    Please Login or Register  to view this content.

    I forgot to mention I changed the sheet details for the vlookup code.
    -
    VlookupTable.jpg
    Last edited by davesexcel; 11-06-2018 at 03:16 PM.

+ 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. Unhide specified sheers based on selection with combobox in a userform
    By Excellover2016 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2018, 12:19 AM
  2. [SOLVED] Hide/unhide based on ComboBox value and CheckBox value
    By Rzzberry in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-31-2017, 11:54 AM
  3. [SOLVED] Hide and Unhide a Combobox based on Criteria met in another Combobox
    By BONCH in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2017, 08:13 PM
  4. [SOLVED] Hide/Unhide Columns based upon Active X Combobox value
    By stephenanderson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2016, 04:36 PM
  5. Hide/Unhide Rows Based On Drop Down Selection
    By QABrian in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-14-2014, 11:53 PM
  6. [SOLVED] How VB code can unhide/hide rows based on combobox selection?
    By jgomez in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-04-2012, 01:25 PM
  7. Hide and unhide rows based on combobox
    By pkling in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2010, 03:25 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