Received some awesome help for an issue yesterday - hoping someone is good enough to help me with another item on my wish list.
I have multiple userforms in an Excel project, some of these are fixed size and fairly static, but a couple are used for note entry - what I would like to do is make these userforms more like a real Windows forms with resizable borders and controls. I understand resizing the controls is coded in the Userform_Resize event but if the window is not resized, the code never runs. Also, I don't want to 'zoom' the controls but instead resize them to fit whatever size the userform is.
A normal Window can be resized by clicking on the Border and dragging, but not VBA userforms unless they are modified somehow using the Windows API - I've looked into this but it's totally beyond me. I get the fact the SENDMESSAGE function is used but any more than that causes me endless pain.
Is it possible to have resizable userforms without being a rocket scientist?