Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frustrating options in Excel vs 2003 | Excel Discussion (Misc queries) | |||
Very Frustrating - Please Help! | Excel Worksheet Functions | |||
Subclassing in Excel ! ...So frustrating ! | Excel Programming | |||
Simple but frustrating | Excel Programming | |||
Subclassing the EXCEL7 window | Excel Programming |