Moving amouse over controls

  • Thread starter Thread starter CHEPChap
  • Start date Start date
C

CHEPChap

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Debugging: how to see entire string var value? 6
Excel Move or Copy Stopped Working? 0
Userform Control Enter Event 2
Creating a custom Commandbar 1
delete workbook from one location and save workbook to new locatio 5
Error coding for access of locked cells... 7
Tooltip text over a label 4
Comparing a vba variable to a range of cells 5

Back
Top