Create a flyout when cell is clicked

I think I may be trying to do the impossible here, but...

What I want to do is be able to click on a cell [Private Sub Worksheet_SelectionChange(ByVal Target As Range)]

That cell will have a range of cells associated with it, and a flyout will appear (much as the cell Comments flyout) which will contain the range of cells associated with that cell.

I would also like to know how to add a little "arrow" (as per the cell with Comments) that triggers the flyout.

I'd like the flyout to be a sort of popup range of cells and look like a range of cells, but if I have to create a comment with the data, then I'll do it that way...

The example image I've attached sort of shows what I want to do, but I'd prefer it to not looks so much like a comment!

Thanks.

Hi

On this spread sheet right clicking on cell c12 will open a userform that displays your range of cells.

Thanks for that, it's a start.

It sort of does what I want it to do, I'll massage it though.

I do have one problem with the "right-click" activation, when the form is closed the standard right-click menu appears, is there any way to suppress that?

It's OK, I figured out what bit stops the menu.

Cancel = True

Thanks for your help. I've now got examples of both the comment box option and the form/listbox option. I'll have to see which option the client prefers!