Excel VBA Run Macros on hover over shape

New Videos EACH WEEK on our new channel here:

I had this idea of adding a help pop-up over a shape on mouse over from a question on a Mr.Excel forum and for the most part Dan over at Excel VBA Is Fun helped me out with it, which you can see his video here:
Thanks so much Dan.

[RandyAustin]

I have started a brand new Excel For Freelancers YouTube channel with new and UNIQUE training videos each week. I would love your feedback on it:

[stevennye]

excellent information, your production quality has gretly improved over the last several years.

[felipescherer]

Great workarround for the lack of Hint for Shapes in Excel. Thanks!

[ofjvyxq]

You can also get this effect without any additional shapes by just adding a Comment (older versions) or Note (newer versions) to the cell behind button/shape. It doesn't look as good and is less flexible, but it's even easier than this. Also, it doesn't require VBA. All that said, this is still a GREAT workaround to the half-baked Excel object model that has remained unfinished for decades. It appears Microsoft no longer has the talent (or desire) to finish it, instead trying to foist new products (Power Apps, etc) on people that would be unnecessary VBA were ever finished.

[miguelros]

en ves de formulario, le coloco esos rectangulos de colores para luego mandarlos a traz y desaparecerlos, buena idea.

[sswapnil]

This is awesome I will give full marks sir....

[iameDi]

You are smart! thank you.. I like your content!

[lima]

Very nice. Very good explanation. Thanks so much.

[umarilyas]

Is there a way to put like an IF condition before thise to like switch on and off this feature?

[sudarmasampath]

Thanks For lot.And Can I handover that VB code in notepad.

[rnamnicattgscindia]

its an awesome tutorial sir! Thanks a lot

[sanaaaa]

Thanks Randy for this. Macro related question, I am trying to build a macro that connects any two shapes with a line, but not 'fix' it to specific
To give a bit of context:- The excel sheet is being used in a presentation, which will have a number of boxes. - I want to be able to use a macro that inserts a line between any two boxes that are selected. - If I select 2 different boxes, the same macro will still insert a line between.
I was wondering if you think that is possible?

Many thanks

[martindraganski]

Very clever, pity that it needs an ActiveX Control, oh well, stuff Mac users, right?!

[ssambhham]

Excellent explanation.
It works well if the bigger shape is significantly larger than the smaller shape. But it does not work so well if the shapes are minute such as when you have a small help icon. The way it is described in the video requires the user to move slowly outward to give it enough time over the area of the larger shape to be detected and consequently hide the help shape again. Otherwise, as it is doing with me, the help shape remains visible.
Any thoughts or alternatives?

[ronniewirawan]

I try your code, and now I'm stuck on it whit label are not behind shape? Why it happen, I use Excel 2007? can you give me solution about my problems?

[raghavchadha]

Thanks Randy for this. However, I can't get the label 'behind' the shape. I'm using this approach to create a rollover; however, due to this, whenever I try to click on that shape (to activate the macro associated with the shape), it ends up selecting the label. Any ideas ? I'm using excel 2007

[ClotBlock]

Hey Randy, I really like the video. However I'm having issues with moving my shape in front of the active x labels. The labels themselves will move forward or backward relative to each other, as will shapes if I have more than one, but the shape itself will not move in front of the labels. If I just make the labels transparent, it won't matter but I was curious if you had any thoughts on how to fix this. Thanks for the video!

[star_-xnwt]

This video has been so helpful. But is it possible to create two buttons on the same sheet? I have two shapes that are hyperlinked to other sheets and I would like to use the hover over effect on them so that they light up when the cursor rolls over. I have been able to do one with the method described in the video and it works perfectly, but when I to add the code to the second one nothing happens and the first one stops working. I am not an excel expert, just a fiddler and so I don't understand the order of the coding too well. Any help will be appreciated. Thanks!

[James-uzse]

Can you run this behind another application which is full screen so the macro’s on hoover still activate?