1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating an Information Hub. Matching, Linking & Displaying

Discussion in 'VBA Macros' started by HHBerty, Feb 14, 2019 at 9:26 AM.

  1. HHBerty

    HHBerty New Member

    I make static caravans. I'm looking to create an information hub and would like some feedback on the best way to do this with formulas please? This is my menu:

    The plan
    • When a Sage code (6-digit part code) is typed in as shown above, I would like it to offer the option 'View Photo?'. The user would then be able to click on the link to view, then be able to return to the main 'Menu' screen.
    • I would also like the user to be able to 'View Fitting Instruction?' for the same Sage Code, then be able to return to the main 'Menu' screen. Again each fitting instruction would have a unique reference number.
    • If the user wants to see a part fitted in a certain room, they would be able to type in a Range Code, Mark Number and View. Again with a link to images (each image would have a reference number), then returning to the main menu.
    1. I think this is all possible, am I correct?
    2. What would be the best approach?
    3. I'm not familiar the VBA's. Can it be done with slicers or macros?
    4. What is the formula needed for: when I type in a 6-digit number, it will then find and ask if I want to open the corresponding reference file (which is a jpeg image)?
    5. What would the formula/s be for multi-argument/conditions in the plan above?
    If possible, could you explain the various parts of any macros you post, as I would like to understand the workings of them?

    Kind Regards and Many Thanks.
  2. HHBerty

    HHBerty New Member

    I'm thinking the DGET formula could be used, but how would I get it to link to the file name I enter (e.g typing in Sage Code: '123456' would ask me if I want to view the '123456' jpeg image), then open it if YES?

Share This Page