Help with VBA to make popup window on another sheet.

[Demention]

Hi everyone,

I've always used excel for the more basic functions and know nothing about coding, but I'd love to make this as easy to use for the end user.

Here's my problem:
I have a workbook with 2 sheets. Sheet 1 contains a couple buttons with code that I've found online to help filter to info that the user would need. Sheet 2 has the item that they would be using in a named table format which does contain images and text.

What I would like is for the user to click a button which would then display the table from sheet 2, in a pop up window or userform* on sheet 1 which can be closed without navigating away from sheet 1.

I tried the pastepicture code but I have no idea how to get it to work, or even if it does what I'd like it to. Also with there being over 400 tables, I'm not sure if it would be practical.

I did find a thread on here before but the file was corrupt and lead me to asking for help.

I've included a sample workbook with a basic example of what I have. There are multiple vehicle manufacturers and different options for each model that I have excluded but it all follows the same format.

If anyone could help me I would be extremely grateful.

Thanks in advance

 

[Nebu]

Hi:

You may want to check out the following option.

https://www.extendoffice.com/documents/excel/2098-excel-drop-down-list-with-images.html

Thanks

 

[Demention]

Hi Nebu,

Thanks for the reply but it's not what I was thinking. I've changed my idea a bit and will open a new thread.

Thanks!