Hi, all Ye Gurus!
                  I created an image on a worksheet. If I move the mouse cursor/pointer over that particular image, there should display a customized Form.
                 Can this be done? How are the codes to be written for the mouse cursor/pointer to execute the procedure?

                    Appreciate your ideas and help.

  CHIN

Unfortunately the mouseover event is not available in Excel, do you need this to work in this manner or can you survive with a click of the object/picture?

Cheers

Matthew

Thanks again Matthew.
It would be quicker to view the form and select in this way rather than to wait until the next page/form is displayed.

CHIN

Hi

It can be done by this way

Private Sub Image1_MouseMove(ByVal Button As Integer, _
        ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
Dim b As Byte

b = b + 1
If b <= 1 Then
    UserForm2.Show
End If

End Sub

-vemaju

Which version of Excel are you using Vemaju?

Matthew

Hi

Currently I'm using Excel 2003, but I suppose it's working in any version beginning from 97

-vemaju

I have checked out MSDN and found that the mousemove event should only work with a chart object, I can't get it to work for my XL2K with an image object. How have you got it to work for an image? Have you declared you image as a collection? I really am interested.

Cheers

Matthew

Sorry
I misread the question. I thought it was question about forms.
I added image control to the form and the image conrol has a mousemove event.

-vemaju

I found a solution

Add an image control from Control Toolbox to the worksheet.
Add a picture to that control.
Image control has an MouseMove event where you put your code to open a custom UserForm

I hope this works

-vemaju

Excellent solution. I had forgotten about using control images rather than regular images. It now works for me, but I dont know about Chin whose question it was.

cheers

Matthew