Change text colour with MouseMmove?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings & TIA for your help
I've been wondering, in Excel, if it is possible to mimic the behaviour of hyperlink text on many web pages, where the text changes colour when the mouse pointer is in the vacinity? (and of course change back when the mouse is moved away) The text box/cell should of course also function as a hyperlink. I thought maybe a TextBox active X control and use of the MouseMove event might be the way to go, but no success so far
 
It seems to me that you can use mouse move to set a color, but there is no
event that's great for resetting the color. I suppose you could set a timer
of some sort but that's a kludge.

Private Sub TextBox1_MouseMove(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)
TextBox1.BackColor = RGB(0, 0, 255)
End Sub

--
Jim Rech
Excel MVP
| Greetings & TIA for your help,
| I've been wondering, in Excel, if it is possible to mimic the behaviour of
hyperlink text on many web pages, where the text changes colour when the
mouse pointer is in the vacinity? (and of course change back when the mouse
is moved away) The text box/cell should of course also function as a
hyperlink. I thought maybe a TextBox active X control and use of the
MouseMove event might be the way to go, but no success so far.
|
 

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

Back
Top