Subclassing Excel !!! So frustrating !!
 

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 be much appreciated .

Regards.