+ Reply to Thread
Results 1 to 6 of 6

Biologist, need help creating dynamic & interactive biology tool.

  1. #1
    Registered User
    Join Date
    09-15-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    3

    Biologist, need help creating dynamic & interactive biology tool.

    Hello,

    I am a biologist and I am interested in making an interactive animal kingdom tree using excel. I know there might be better tools to accomplish this, however my department head made it very clear that he needs it be an excel workbook. Here is how I would like it to work:

    - In one column there is a variety of animal classes such as mammals, birds, fish, etc.
    - Clicking on one of these animal class buttons/cells will bring up a brief list of corresponding animals. For example, clicking on fish will bring up a list next to it (it MUST be on the same spreadsheet) that includes salmon, tuna, bass, etc.).
    -Clicking a specific species of animal on this adjacent list will bring up an image next to it of the corresponding image of the animal. For example, clicking "Tuna" will pull up an image of a tuna next to it (I would like to have the images stored on the workbook, perhaps in different spreadsheets).

    Another problem I am facing is that the end product must be somewhat protected, for example, I don't want end-users to be able to select cells.

    I tried using slicers but that didn't turn out too well. I'm currently trying buttons with limited success...

    I have included a process diagram of what I am envisioning. Ideally I would like the second column which contains examples to change depending on which class from the previous column is selected. I would also like the image(s) hidden by default until a particular example is selected. I'm ok with having a reset button, but I would really like this tool to be dynamic - allowing you to click through multiple classes/examples without having to manually reset the page each time.

    http://imgur.com/hswTCKW

    I appreciate any help you can offer. Thanks!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: Biologist, need help creating dynamic & interactive biology tool.

    Without seeing your data, I envision that you might be able to accomplish this with cascading combo boxes--sometimes called dependent combo boxes. Here is a link to how they work and how to set them up.

    http://www.contextures.com/exceluser...omboboxes.html

    The last part, I suspect might be achievable with using hyperlinks to specific .jpg or .png files which contain individual pictures. Using hyper links will keep your file size down and allow for a faster response and retrieval.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    09-15-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    3

    Re: Biologist, need help creating dynamic & interactive biology tool.

    I don't think a combo box is what I am looking for. I would like the interface to function more or less like the diagram I provided in my original post.

    http://imgur.com/hswTCKW

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: Biologist, need help creating dynamic & interactive biology tool.

    Did you look at the explanation of the cascading combo boxes before dismissing the idea as this concept closely resembles what you are asking for in your diagram.

    For example if you select Fish in your first combo, then in the second combo, you will only see Trout, Tuna, Crappie, Bass, etc. Then the hyperlink to the picture.

  5. #5
    Registered User
    Join Date
    09-15-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    3

    Re: Biologist, need help creating dynamic & interactive biology tool.

    Once clicked on, I would like all of the paths for a given class visually available for as long as the class is selected for. I would also like the image to be displayed next to the example column once selected (I would prefer not to have a hyperlink).

    I want this tool to be visually stimulating, dynamic, intuitive, and interactive - and I don't think cascading combo boxes will allow me to achieve this.

  6. #6
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,613

    Re: Biologist, need help creating dynamic & interactive biology tool.

    Use listboxes instead of comboboxes.
    Ben Van Johnson

+ 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. Help creating interactive userform.
    By atv35 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2013, 03:46 PM
  2. Creating Interactive Map
    By hawkinsr86 in forum Excel General
    Replies: 6
    Last Post: 11-07-2012, 11:00 AM
  3. Interactive Results Tool
    By housinganalyst in forum Excel General
    Replies: 2
    Last Post: 03-05-2012, 11:34 AM
  4. creating an interactive spreadsheet
    By cl0ne in forum Excel General
    Replies: 10
    Last Post: 03-07-2011, 09:51 AM
  5. [SOLVED] Creating an interactive Global Map in Excel
    By Yasmin in forum Excel General
    Replies: 0
    Last Post: 03-10-2005, 10:06 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