Blogs from Wise Owl on User forms in VBA macros

Installing the Microsoft Date and Time Picker for VBA

Posted by Andrew Gould on 24 February 2015

Some versions of Windows don't include the very useful Date and Time Picker control. This blog explains how to install the mscomct2.ocx file to get it back!

How to insert ActiveX controls after CANNOT INSERT OBJECT message

Posted by Andy Brown on 29 January 2015

When using Excel, we owls have had problems inserting ActiveX objects after recent security updates. Here's a solution which worked for us!

Getting the Calendar control to work in Excel 2010 onwards

Posted by Andy Brown on 13 January 2014

The calendar control for user forms is built into versions of Excel up to 2007, but has to be imported for later versions - this blog shows how to do this!

Advanced controls in userforms with VBA macros

Posted by Andy Brown on 28 February 2012

The two previous parts of this mini-blog have shown how to draw forms and how to write code to handle form events. This final part shows how to add some of the more exotic controls to user forms, like combo boxes, list boxes, multipage controls, spinners and option buttons.

Writing VBA macros to work with user forms

Posted by Andy Brown on 28 February 2012

The previous part of this three-part series showed how to draw user forms; this part shows how to write macros to get them to work (the final part shows how to use some of the more advanced controls, such as combo boxes and MultiPages).

Drawing UserForms in the VBA code editor

Posted by Andy Brown on 28 February 2012

Learn how to create your own custom dialog boxes in VBA, using UserForms. This is the first part of a three-part series (the other parts are on Writing Code for UserForms and Creating Advanced Controls).