Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
call up a calendar
I WOULD LIKE TO PROGRAM A COMMAND BUTTON TO PULL UP A CALENDAR CONTROL. ONCE
DATE IS SELECTED, HAVE CALENDAR HIDDEN. CAN ANYONE HELP? THANKS IN ADVANCE FOR THE HELP! -- icebreaker914 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
call up a calendar
I did something like what you want using my Personal.xls. Here's something
for you to work with: 1)Add a code reference to a Microsoft Calendar Control 2)Add a Form to your project and insert the Calendar Control to it. (I named mine Calendar1) 3)Here's the form's code: Option Explicit Private Sub Calendar1_Click() Unload Me End Sub 4)Here's the code I put in a Workbook module: Option Explicit Sub ShowCalendar() Dim newDate Load frmCal newDate = Format(Now(), "mm/dd/yyyy") frmCal.Calendar1.Value = newDate frmCal.Show End Sub 5)Then, I just created a keyboard shortcut for the ShowCalendar macro: ToolsMacroMacros Select ShowCalendar Click Options and select the shortcut keys: [Ctrl]+[Shift]+C Anyway, that's what I did. You'd just have to engage the macro to a button, instead. Does that help? -- Regards, Ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
call up a calendar
Icebreaker, have a look at Ron's site and see if this will work for you
http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "icebreaker914" wrote in message ... I WOULD LIKE TO PROGRAM A COMMAND BUTTON TO PULL UP A CALENDAR CONTROL. ONCE DATE IS SELECTED, HAVE CALENDAR HIDDEN. CAN ANYONE HELP? THANKS IN ADVANCE FOR THE HELP! -- icebreaker914 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
call up a calendar
Place this code in a general module and assign it to your command button Sub ShowCalendar() Sheets("Sheet1").DrawingObjects("Calendar1").Visib le = True End Sub Place this code in the relevant worksheet module Private Sub Calendar1_Click() ActiveCell = Calendar1.Value Calendar1.Visible = False End Sub -- XL2003 Regards William "icebreaker914" wrote in message ... I WOULD LIKE TO PROGRAM A COMMAND BUTTON TO PULL UP A CALENDAR CONTROL. ONCE DATE IS SELECTED, HAVE CALENDAR HIDDEN. CAN ANYONE HELP? THANKS IN ADVANCE FOR THE HELP! -- icebreaker914 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
On call calendar question | Excel Discussion (Misc queries) | |||
find free sharware to include calendar pop or use calendar in cell | Excel Discussion (Misc queries) | |||
how do i export excel calendar info to outlook calendar? | Excel Discussion (Misc queries) | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
import calendar items from excel into outlook calendar | Excel Discussion (Misc queries) |