Dear all,
I want to create a very small userform, without title. It seems min height should be ±30 and width ±102.
HOwever, I see this demo:
How to do this ????
Thank you.
DOD
Dear all,
I want to create a very small userform, without title. It seems min height should be ±30 and width ±102.
HOwever, I see this demo:
How to do this ????
Thank you.
DOD
All supposing you have the workbook used in that video then all the code you need is in that - you can trace it from the click event of the 'Show Title' checkbox on UserForm1.
A bigger problem is that was written some time ago for 32 bit Excel, As it makes extensive use of the Windows API it will need editing to update it for 64 bit but the functional code to remove the title bar is very simple.
Hello
Thank you for answer. I understood only now size limitation disappear when title is off. I can continue with this information.
Don’t have an account yet? Register yourself now and be a part of our community!