Blog posts

Show a UserForm with a ListBox which can be filtered by typing one or more characters into a TextBox.

Multiple choice UserForm in VBA using a ComboBox - this UserForm allows a user to make a choice when there are more than just Yes/No or OK/C

Programmatically adding controls to a UserForm and reacting to their events

Something that brings a UserForm to life is, when the mouse pointer hovers over a Button, there's an indication that the Button is clickable

A FaceId, in VBA, is a small picture/icon added to a CommandBarButton which is an item in a menu. The main menus in all Office...

The following code will make the entire UserForm transparent. I'm sure there is a practical use for this, I'm just now sure what it is!...

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...

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...

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...