subclassing

Hi, I have lately been doing some research on the subject of how to use the GDI+ library for drawing in vba. One thing I wanted to do was to be able to perform smooth zooming on userform images (The native userform zoom property is no good as it doesn't keep the image in the center and moves...

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...

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...

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...

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...

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...