Display a table in a pop-up window when a hyperlink is clicked

[pkrish]

Hi Everyone,

I was wondering if there is a way in excel-vba to do this.

In sheet A, I have 10 tables. Each table is assigned a table name and has two columns (a list of fields in column 1 and the corresponding data types in column 2). I have added a hyperlink to the cell which contains the table name ('Sheet A'! C 2:D 2) . When you click on the link, it takes you to Sheet B and the highlights the range where the actual table exists ('Sheet B'! I 18:K 25).

I was wondering if there is a way by which the table 'Sheet B'! I 18:K 25 can be displayed in pop-up window when the hyperlink ('Sheet A'! C 2:D 2) is clicked.

I really appreciate your help!

Thanks,
PK

 

[Jaafar Tribak]

Do you want the table in the popup window to be editable or just wiewable ? If you don't need to edit the table in the popup window then I think the best is to display a copy of the table in a modeless userform otherwise ( ie: if editable ) you could display it in a new workbook window with some tweaking tricks.

 

[pkrish]

Thanks a lot Jaafar! I really appreciate your help. I am going to give this a try.