The following code will hide the whole title bar of the UserForm window. Why would you want to do this? The only time I do is when showing a modeless 'progress bar' dialog. Leave a comment to let me know why you would do this!
1. In the UserForm's code in the declarations area, add the Windows API calls and associated constants
2. And in the UserForm's code in the procedures area, add this SetNoTitleBar procedure
3. And from the UserForm_Initialize event, call the SetNoTitleBar procedure
4. Display the UserForm (in this example called UserForm1) from a standard code module eg
5. You will need to reduce the height of your UserForm as it doesn't automatically adjust for the absence of the title bar as you see in the following images ...
UserForm with title bar:
And UserForm without title bar:
