Blog posts

Jun 207 min read

Version Control for VBA

Turn back the clock and revert to an earlier version of your code or just view changes that have been made since an earlier point in time.

2 comments

Jul 28, 20233 min read

Multiple choice UserForm in VBA using a ComboBox

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

0 comments

Mar 31, 20235 min read

Dynamically adding controls to a UserForm and reacting to their events

Programmatically adding controls to a UserForm and reacting to their events

0 comments

Mar 8, 20233 min read

Changing UserForm Button colour on mouse hover

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

0 comments

Aug 25, 20223 min read

VBA and FaceIds

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

0 comments

Feb 26, 20221 min read

Make a UserForm transparent

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

1 comment

Feb 25, 20221 min read

Hide a UserForm's title bar

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

1 comment

Feb 25, 20222 min read

Working with a UserForm's close button (the 'X' button)

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

0 comments

Feb 24, 20222 min read

Add an icon to a UserForm's title bar

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

0 comments

Articles: Blog2