I have a spreadsheet where I want a message to appear when I move the
mouse over a series of buttons. Using the MouseMove I can generate a
message by placing msgbox "blah blah blah" in the code, but this box
stays when the mouse moves off the button. I have to click the OK to
make it disappear. Can anyone let me know how I can create code so that
a box appears (or, if this is not possible a status bar message may have
to do) whenever the mouse moves over the control but disappears when you
leave it?

Many thanks

Colin Sidwell

*** Sent via Developersdex http://www.developersdex.com ***

You can add a comment to the cell behind the controls. Position the buttons
so a portion of the cell is visible. Now the comment will appear when the
mouse is near the button.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"CHEPChap" wrote in message
...
I have a spreadsheet where I want a message to appear when I move the
mouse over a series of buttons. Using the MouseMove I can generate a
message by placing msgbox "blah blah blah" in the code, but this box
stays when the mouse moves off the button. I have to click the OK to
make it disappear. Can anyone let me know how I can create code so that
a box appears (or, if this is not possible a status bar message may have
to do) whenever the mouse moves over the control but disappears when you
leave it?

Many thanks

Colin Sidwell

*** Sent via Developersdex http://www.developersdex.com ***