Hi dear excellers,
I have put together this project which subclasses userforms (can be extended to other windows) and I would like to know if it works as expected for trapping window messages. I am particularly interested to know if the project is stable enough. Meaning: It dosen't shuts down...
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.