how do I make a hidden object (textbox) Visible when moving the cursor over a
visible object, using the MouseOver-event

There is no MouseOver event in Excel. See the following:
http://www.mrexcel.com/board2/viewto...mouse+location

Mike F
"willg" wrote in message
...
how do I make a hidden object (textbox) Visible when moving the cursor
over a
visible object, using the MouseOver-event

As Mike said MouseOver is not supported.

If your objects are ActiveX controls from the Controls toolbox toolbar you
can use MouseMove. Add two labels and a commandbutton and the following into
the worksheet module

Private Sub Label1_MouseMove(ByVal Button As Integer, _
ByVal Shift As Integer, _
ByVal X As Single, ByVal Y As Single)
If Not CommandButton1.Visible Then
CommandButton1.Visible = True
End If
End Sub

Private Sub Label2_MouseMove(ByVal Button As Integer, _
ByVal Shift As Integer, _
ByVal X As Single, ByVal Y As Single)
If CommandButton1.Visible Then
CommandButton1.Visible = False
End If
End Sub

In the above the CommandButton1 example does not need to be from the
controls toolbox, could be any shape or object that supports visible.

Regards,
Peter T


"willg" wrote in message
...
how do I make a hidden object (textbox) Visible when moving the cursor
over a
visible object, using the MouseOver-event