PDA

View Full Version : VBA Calendar



jcutler
03-04-2014, 07:24 PM
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.

GTO
03-05-2014, 12:47 AM
...Running Office 2010 University...

Hi there,

If my 'detective' skills are off, please forgive. Are you a student and is this an assignment? I ask, as while you can certainly find examples of userform-based calendars, I would be doing you a disservice in simply pointing you to such a 'already written' example.

Mark

jcutler
03-05-2014, 05:17 AM
Thank you for the quick response. This is not an assignment.

GTO
03-05-2014, 01:13 PM
Hi J,

Near the top, go to the knowledgebase, then use Search. Enter 'calendar' as the search term. Several nice examples, including Steve Lucas' at: http://www.vbaexpress.com/kb/getarticle.php?kb_id=543

Hope that helps,

Mark

Tom Jones
03-05-2014, 02:14 PM
Cross Post

Calendar control for office (http://www.excelfox.com/forum/f2/calendar-control-for-office-1723/)

jcutler
03-06-2014, 03:33 PM
Thank you both very much for your help.