Adding a Button (and a ComboBox) to the Ribbon
Adding a Button to the Ribbon menu is surprisingly easy. If you follow this post, you will end up with both a Button and a ComboBox.
top of page
Blog posts
Search
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
Mar 10, 20231 min read
VBE_Extras now available in Microsoft Access
It's taken me 3 months (Access is so, so different to other Office applications!) but VBE_Extras now works from the VBE hosted by...
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
Feb 24, 202323 min read
Calling C# code from VBA (COM interop)
Update October 2024: This post uses Visual Studio and/or RegAsm to 'statically' register your C# library before it is loaded and used by...
Jan 18, 20233 min read
Refactor / rename in VBA
One of the commands that is provided by VBE_Extras is the ability to rename a declaration and all the references of that declaration....
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...
Aug 10, 20224 min read
Let the user choose a single file
A 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,...
Jul 29, 20221 min read
Automatically adding Properties
Get fed up with manually typing out Properties? VBE_Extras can now automatically add Properties for module-level variables and Type...
Jul 27, 20223 min read
Automatically adding factories
What'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...
Articles: Blog2
bottom of page