Blogs from Wise Owl on User forms in VBA macros

Showing blogs 1-4 (out of 4)

Getting the Calendar control to work in Excel 2010 onwards

Posted by Andy Brown on 13 January 2014 | 1 comment

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!

Tags:   Excel | Excel Visual Basic    |    VBA macros | User forms

Advanced controls in userforms with VBA macros

Posted by Andy Brown on 28 February 2012 | 4 comments

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.

Tags:   Excel | Excel Visual Basic    |    VBA macros | User forms

Writing VBA macros to work with user forms

Posted by Andy Brown on 28 February 2012 | no comments

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

Tags:   Excel | Excel Visual Basic    |    VBA macros | User forms

Drawing UserForms in the VBA code editor

Posted by Andy Brown on 28 February 2012 | no comments

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

Tags:   Excel | Excel Visual Basic    |    VBA macros | User forms