Notthekingofexcel
New Member
- Joined
- Oct 13, 2014
- Messages
- 10
Hi,
Example:
I have created document in excel which is a map of an heat map of a area of London. The cells that make up that area change colour when the area becomes occupied. What I want to do is click the cells so it opens a pop up window of the data. Currently I have a hyperlink that takes me to the sheet the data is in, but you can still see all the other data.
Is it possible to have a popup window containing 7x9 set of cells or is it possible to show only the set of data that has been clicked when it goes to that sheet?
The popup window is my preference happy for it to be VBA code if it is explained simply.
Thanks in Advance.
Example:
I have created document in excel which is a map of an heat map of a area of London. The cells that make up that area change colour when the area becomes occupied. What I want to do is click the cells so it opens a pop up window of the data. Currently I have a hyperlink that takes me to the sheet the data is in, but you can still see all the other data.
Is it possible to have a popup window containing 7x9 set of cells or is it possible to show only the set of data that has been clicked when it goes to that sheet?
The popup window is my preference happy for it to be VBA code if it is explained simply.
Thanks in Advance.
