The VBA Help blog

A frustration that I have with using AI to support me in writing VBA code is generating UserForms ... specifically the UI part of UserForms. Here's a solution using an AI skill, a .frxml file and VBE_Extras.

mscomct2.ocx contains the Animation, Date and Time Picker (DTPicker), FlatScrollBar, MonthView and UpDown Controls. This post describes how to download and install mscomct2.ocx, and how to add the Controls to the Toolbox and a UserForm.

The standard VBA.InputBox (and Application.InputBox, available if working in Excel) only allow you to enter a single line of text. What to do if you want to allow a user to enter multiple lines of text? Use a UserForm with a multiline TextBox ...

This post demonstrates how to use the SetPixel and GetPixel Windows API Functions to set (and get) the colour of individual pixels on the surface of a UserForm.

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

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.

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