JohnJul 28, 20233 minMultiple choice UserForm in VBA using a ComboBoxMultiple 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
JohnMar 31, 20235 minDynamically adding controls to a UserForm and reacting to their eventsProgrammatically adding controls to a UserForm and reacting to their events
JohnMar 8, 20233 minChanging UserForm Button colour on mouse hoverSomething that brings a UserForm to life is, when the mouse pointer hovers over a Button, there's an indication that the Button is clickable
JohnAug 25, 20223 minVBA and FaceIdsA 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...
JohnFeb 26, 20221 minMake a UserForm transparentThe 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!...
JohnFeb 25, 20221 minHide a UserForm's title barThe 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...