mouse over for a button
 

Does anyone know how to create a mouse over pop-up message for a button?
If so, please help.

Thanks


--
gonger
------------------------------------------------------------------------
gonger's Profile: http://www.excelforum.com/member.php...o&userid=34797
View this thread: http://www.excelforum.com/showthread...hreadid=553230

mouse over for a button
 

If anyone else replies with a direct answer, then ignore this response:

You can make any cell into a button. Let's use cell E10. Color its
background, put a border around it, and insert any comment in it.

The comment will respond to the MouseOver. In worksheet code, enter
something like:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Range("E10")) Is Nothing Then
Else
MsgBox ("Hi there")
Range("E11").Select
End If
End Sub

If you click on E10, it will behave like a button. I admit this approach is
a little silly, but if no one else responds.......
--
Gary''s Student


"gonger" wrote:


Does anyone know how to create a mouse over pop-up message for a button?
If so, please help.

Thanks


--
gonger
------------------------------------------------------------------------
gonger's Profile: http://www.excelforum.com/member.php...o&userid=34797
View this thread: http://www.excelforum.com/showthread...hreadid=553230