copymemory

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, I have just completed this code which as the thread title says, it adds a balloon tip to the worksheets of your choice... Having a tooltip displaying info about the sheet when placing the mouse pointer over the tab can be useful and fun. The code is based on the sheet CodeName so that...

Hi dear forum, Workbook Sample I am posting here a self-contained vba approach for getting members of an object without the need for an external dll such as the well known TLBNINF32.DLL . The GetObjectFunctions function takes two arguments : (1) The object being browsed and (2) an optional...

I stumbled on an oddity while experimenting with lightweight objects in vba that I thought maybe would be worthwhile sharing .. Not of much use but, interesting nevertheless. I discovered by accident that when a runtime error occurs while there is a lightweight object in memory, Macros get...

Hi all, I have been reading on the layout of COM objects and Virtual Tables and I have managed to hack Excel Methods and Properties .. It's surprisingly easier than I had thought but just as I was getting excited about this idea and it's enormous potential for adding new functionality to Excel...

Hi Dear all. Strictly speaking RaiseEvent is not a procedure but looks and does the same as one (ie: Executes code) . It also accepts arguments which can be passed ByVal or ByRef. When an argument is passed ByRef to a Sub/Function , the procedure can modify the argument itself however this...