PDA

View Full Version : VBA UserForm Based Calendar Substitute DatePicker Control For All MSO Versions



pookster
03-05-2014, 08:27 AM
Not sure if I am posting this in the right forum. If not, my apologies. I need to create a calendar userform. An activex command button would placed in a cell that when clicked it would call up the calendar. Running Office 2010 University. Does not contain datepicker control nor calendar control. Any guidance greatly appreciated.

Admin
03-05-2014, 08:43 AM
Hi pookster,

Welcome to board!!

See Calendar Control for all Versions (https://sites.google.com/site/e90e50/calendar-control-class)

Ingolf
03-06-2014, 02:14 AM
Cross post

VBA Calendar (http://www.vbaexpress.com/forum/showthread.php?49096-VBA-Calendar)

bakerman
03-06-2014, 11:49 AM
Dear pookster,

Please read forum rules regarding cross-posting.

http://www.excelfox.com/forum/f25/message-to-cross-posters-1172/#post5326

Excel Fox
03-06-2014, 08:04 PM
Pookster, you can also download the userform based calendar control from http://www.excelfox.com/forum/f10/non-activex-calendar-monthview-control-44/

Instead of using an activex control command button to invoke the calendar, you can just right-click on the cell, and run the calendar from the contextual menu.