It works. Show the code.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"RAFAAJ2000" wrote in message
...
Hi all,

I have tried writing subclassing code in Excel time and time again but
not
once have I been successful. Either the code just doesn't work or even
worse,
it crashes the application.

I have followed every single step described in many VB codes that I have
seen on the Web and on many VB books and have tried applying them to
Excel\VBA but no luck !.

As a simple example, I wanted to trap the Mouse Move event by subcclassing
the Excel application Window so that a Msgbox pops up whenever the user
hovers the mouse over a given worksheet range . Even this basic
subclassing
code causes the application to freeze or crash !!! Unbelievable !!!

I have seen many good Excel books showing nice API code examples but they
ALL seem to shy away from \ avoid the subject of subclassing despite being
an
extremely powerful technic !!

Does subcclassing not work for VBA\Excel ? Or is it just me who doesn't
know
how to implement it ?? I still don't have a clear answer .

Any thoughts would much appreciated .

Regards.