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.