raiseevent

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 all, MultiColorDragList.xlsm I have been experimentng with the Comctl32 Listbox control in the last few days. The final result looks good BUT there are two major limitations which I should mention upfront beofre getting too excited. 1- ListBoxes can only be added to MODAL UserFoms. 2- No...

I am trying to do certain actions like "Target.Interior.Color = vbYellow" when any value is entered into certain excel cells. I have a KeyPressApi Class StartKeyPressLoop() that monitors the Message loop for keypress messages and the does: MsgBox ("raise event") RaiseEvent...

Hello I've been trying to solve this problem for hours with no success. Please, kick me It should be simple 1, form with labels that are added dynamicaly 2, a common class that catch labels event I prepared a sample with one form and one class code in the form - UserForm1 Dim storeInstances...

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