Blog posts

The close (or 'X') button appears at the right in the title bar of every UserForm. You can control the behaviour when it is clicked, or you can hide it. Why would you want to do that? Normally, you wouldn't. And shouldn't. Normally the user should be able to close a UserForm whenever they want and your code should handle that outcome. However, just occasionally, it might be essential to ensure that a user has acknowledged some text or made a selection ... an example might be

Adding an icon to a UserForm's title bar can help to give a professional look to your UserForm. The source icon must be a .ico file. If the image file you want to use is not a .ico file then you can use one of a number of online image converters to convert it from .jpg or .png etc to .ico ... search along the lines of "convert to icon file". Once you have your .ico file: ​ 1. Add a UserForm to your VBA Project 2. Add an Image control to the UserForm and change its Name proper