How do I enable stretch functionality in my form ? 1

[Recce]

Good day,

I need to know why I need to know why I can't stretch my form in VBA. I am able to add the scroll bars via properties but I can not find anything that will enable me to stretch the form. Could anyone maybe suggest anything ? Thanks

"We know nothing but, that what we know is not the truth..." - Me

 

[combo]

You can either use API to change UserForm window's properties (Stephen Bullen's solution here - 'formfun' file) or emulate this by trapping mouse events (Andy Pooe - sample here).

combo

 

[Recce]

Hi combo,

Thanks for this ! Works well !

"We know nothing but, that what we know is not the truth..." - Me