Hover text on mouse over on button

[jss979]

Hey guys -

I've created several buttons that link to macros that I have put in the first row of my sheet. I've freezed the panes so they won't move so you can see the buttons form wherever you are so you can use them. However, I'd like to describe what the buttons do somewhere so it's easy for users to use them...

I was thinking the easiest way to do this would be when you hover over the button it shows text in a a little pop up window...like if you hover over an image sometimes there is text that appears.

Is there VBA code that I can write to make that happen? How would I then tie it to a button? To create the buttons under developer I just did Insert, Form Control, Button...

Thanks in advance for your help!
Josh

 

[pgc01]

Hi Josh
Welcome to the board

A simple way to do it, that requires no code, is to place the button over a cell and add a comment to the cell. When you hover over the button the comment of the cell under the button will pop out.