scroll simultaneously frames in class module

Hi all,
i have a userform with 3 frames created run-time (code below).

Please Login or Register  to view this content.

The frames should scroll simultaneously (frm1 and frm2 vertically, frm1 and frm3 horizontally). My problem is how to put the scroll events below into a class module to achieve this. Any suggestion?
Thanks in advance

Please Login or Register  to view this content.

Hi pike,
I don't need to create the class module at runtime, just the userform and the group of frames. In the meantime I have tried with the class module below, but it doesn't work. The code doesn't return any error, simply events don't trigger and i don't understand why.

Please Login or Register  to view this content.

class module (Frame_class):

Please Login or Register  to view this content.

Thanks

It works perfectly, just a couple of questions:
- what is the purpose of the variable blnhook?
- it is possible also shown the userform vbmodelessy? I've notice that the property showmodal is commented, in fact the userform disappear immediately after shown
thanks again

I’m trying to do a sort of interface to manage data where I have a main userform and the users open other userforms with different sets of controls depending on what they have to do (and userforms are removed when no longer necessary). Better if all vbmodeless since they might check files too but I didn’t expect this problem. Maybe better create a userform template and “copy” it?

I have done some tests, if the userform is called again directly by name like “Userform1.show vbmodeless” all work, but if called using a variable, dictionary or function works inly if vbmodal (I’ll have more userform, so I can’t call it directly). I have tried to add a initialize and activate event to the userform and the second doesn’t trigger if vbmodeless.

I'll try something similar
thanks again