1. Jaafar Tribak

    Intercepting resetting of vba editor as well as unhandled errors for safe subclassing

    Hi all, As you know, excel doesn't expose many useful events such as when activating excel or when moving or resizing its main window etc... The way to catch these missing events is through subclassing or hooking excel. Both techniques work in compiled programs but they freeze office...
  2. Jaafar Tribak

    WM_COPYDATA to Hook remote Process (Notepad example)

    Hi all- This is not really important to most of excel users but it was a good learning exercise and I thought I would post what I did here. Subclassing office applications via VBA is difficult enough never mind sublcassing a window in a remote process. In order to achieve this, I wrote a small...
  3. Jaafar Tribak

    Extending UserForm capabilities (Min,Max,Restore,Resize and their respective event handlers )

    Hi all, Changing userform styles to add a Max,Min,Restore menu buttons , to make the userform resizeable or to show its icon on the taskbar are techniques we can apply with relative ease with a couple of APIs however associating an event handler for each added functionality is a bit more...
  4. Jaafar Tribak

    Challenging problem : How to make Excel subclassing safe and stable ?

    Hi all. This has been intriguing me for years and i've looked and asked everywhere but nobody seems to know the answer. On most operating systems, subclassing office applications from within VBA crashes the application and worse yet, it can downright lock the whole system. this is a known...
  5. Jaafar Tribak

    Subscript and Superscript characters on userform labels

    Hi, I never noticed that sub/superscript characters couldn't be displayed on userform captions until this was raised on this forum the other day. here is a little hack that i've managed to put together to simulate sub/superscrips via subclassing the userform.I am hoping this could be...

Some videos you may like

This Week's Hot Topics