BY TOPIC▼
EXCEL / VBA BLOGS▼
VBA MACROS BLOGS▼
- Recording macros (1)
- Working with ranges (4)
- Input/message boxes (3)
- Variables, arrays (3)
- Enumerations (2)
- Loops and conditions (2)
- Errors and debugging (2)
- Functions / arguments (3)
- Events (2)
- User forms (6)
- Classes (4)
- References (9)
- Files and folders (4)
- General (15)
- Working with charts (4)
- Flappy Owl (14)
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Blogs from Wise Owl on User forms in VBA macros
Showing blogs 1-6 (out of 6)
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).