Alright, so this seemed like the next logical step for the rollover method:
This one is kinda complicated, I admit. Unfortunately, I didn't really take the time to clean up the spreadsheet file for others to follow (I don't really have the time these days). Sorry. But try to take it apart - and ask me questions if you have them.
I've canvassed some other folks from the Excel community to see if they would want to do a video tutorial of this - and I think that's what it would take.
Have fun!
Mapper.xlsm
This one is kinda complicated, I admit. Unfortunately, I didn't really take the time to clean up the spreadsheet file for others to follow (I don't really have the time these days). Sorry. But try to take it apart - and ask me questions if you have them.
I've canvassed some other folks from the Excel community to see if they would want to do a video tutorial of this - and I think that's what it would take.
Have fun!
Mapper.xlsm
Wow !!! seems like the next logical step to my Budget/forecast file, where I used the shapes for the country, and when double clicked on one of them,checked if there were other shaped selected and unselected it,and highlighted the corresponding info on an adjacent table with Budget and Forecast.
ReplyDeletebut, as you, I don't have the time now to merge both concepts, but definitively will try to !!!
Well feel free to share your work!
DeleteNice work Jordan!
ReplyDeleteCheck this one too I tried with X Y Scatter chart
https://www.box.com/s/62f55uq37pbtxip1nbmz
Very cool. I see you've employed a method similar to Robert's of ClearlyAndSimply.com and Professional Excel Development. My method above is a bit harder to implement - were you able to understand it? I think using a chart tab and Chart event as you have above has certain advantages to the method I've written about on my blog. Just out of curiosity - would you ever recommend (or implement yourself) the method I've described on Option Explicit VBA? - or, do you think that it may be somewhat impracticable?
DeleteThanks again for sharing! I like your blog a lot.
@Jordan I have seen your method using hyperlink mouse hover effect. I have already shared your interactive map link our my FB pages and groups.
ReplyDeleteI would definitely try it when I have to do any location analysis or where ever it fits in. Its always good to have alternate solutions for a problem or scenario
Thanks - be sure to checkout the new website at wordpress, optionexplicitvba.wordpress.com
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteHi Jordan, Great work!
ReplyDeleteWhen using your strategy (smallest distance) to identify the states, I noticed some states (such as CT) are not properly labeled when mouse over (NY is highlighted instead), due to overlapping shape coverage. Do you have a way to rectify that?
Thanks!
Honestly, there's not much you can do aside from make the states bigger or decreasing the cell size (in either case you're adding more sensitive cells). In this example, I added those squares to hover over if I felt you couldn't properly reach the state.
ReplyDeleteI just wanted to say that I love every time visiting your wonderful post! Great information you shared through this blog. Keep it up and best of luck for your future blogs and posts. for more information visit here:- Roadrunner Email Problems
ReplyDelete