JohnOct 25, 20222 minVBE ThemesVBE_Extras will now help you to create and apply text, background and indicator colours, fonts and 'margin indicator bar' (MIB)...
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...
JohnAug 10, 20224 minLet the user choose a single fileA common requirement for VBA macros is to let the user choose a file, often the file will have some data that the macro is to work with,...
JohnJul 29, 20221 minAutomatically adding PropertiesGet fed up with manually typing out Properties? VBE_Extras can now automatically add Properties for module-level variables and Type...
JohnJul 27, 20223 minAutomatically adding factoriesWhat's a factory? For the purposes of this article: it is code within in a Class Module that creates an instance of that Class, assigns...
JohnJul 20, 202213 minVBA AttributesWhat is an Attribute? A name/value pair that specifies some characteristic of a Module or Module-member. All Attributes are hidden when...