Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I add a Calendar/ date picker graphic to an excel doc?
I want to add a graphic that pulls up a calendar and lets someone populate a
field in and excel sheet with a date of their choosing. Is this available? How is it done? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I add a Calendar/ date picker graphic to an excel doc?
enter this code in worksheet object: (ie right click worksheet tab & select
view code & paste there) When you select a cell in range A1 to A20 the calendat form should show - this may do what you want? Private Sub Calendar1_Click() ActiveCell.Value = CDbl(Calendar1.Value) ActiveCell.NumberFormat = "mm/dd/yyyy" ActiveCell.Select End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Not Application.Intersect(Range("A1:A20"), Target) Is Nothing Then Calendar1.Left = Target.Left + Target.Width - Calendar1.Width Calendar1.Top = Target.Top + Target.Height Calendar1.Visible = True ' select Today's date in the Calendar Calendar1.Value = Date ElseIf Calendar1.Visible Then Calendar1.Visible = False End If End Sub -- JB "B_Man57068" wrote: I want to add a graphic that pulls up a calendar and lets someone populate a field in and excel sheet with a date of their choosing. Is this available? How is it done? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I add a Calendar/ date picker graphic to an excel doc?
Got a runtime error "424":
Object Required MessageBox Popup. Debugging caused the program to stop on this line. Calendar1.Left = Target.Left + Target.Width - Calendar1.Width Any Ideas? "johnboy" wrote: enter this code in worksheet object: (ie right click worksheet tab & select view code & paste there) When you select a cell in range A1 to A20 the calendat form should show - this may do what you want? Private Sub Calendar1_Click() ActiveCell.Value = CDbl(Calendar1.Value) ActiveCell.NumberFormat = "mm/dd/yyyy" ActiveCell.Select End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Not Application.Intersect(Range("A1:A20"), Target) Is Nothing Then Calendar1.Left = Target.Left + Target.Width - Calendar1.Width Calendar1.Top = Target.Top + Target.Height Calendar1.Visible = True ' select Today's date in the Calendar Calendar1.Value = Date ElseIf Calendar1.Visible Then Calendar1.Visible = False End If End Sub -- JB "B_Man57068" wrote: I want to add a graphic that pulls up a calendar and lets someone populate a field in and excel sheet with a date of their choosing. Is this available? How is it done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Date Picker problem | Excel Discussion (Misc queries) | |||
pop up calendar using MS DateTime Picker | Excel Worksheet Functions | |||
Is there a way to get a Date Picker Box in Excel? | Excel Discussion (Misc queries) | |||
mscmctl2.ocx ... calendar and date picker sometimes not available | Excel Programming | |||
Creating a calendar in a cell for a date-picker | Excel Worksheet Functions |