É possível inserir datas em uma célula em um calendário suspenso?
Use o seguinte para o Excel 2003.
Adicionando uma caixa suspensa de calendário ao Excel 2003
Insert > Object, scroll down and click on "Microsoft Calendar Control".
Right click the worksheet tab and view code.
Paste the following code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub 'Change this to your range of dates If Not Intersect(Target, Range("A1:A100")) Is Nothing Then Calendar1.Top = Target.Top + Target.Height Calendar1.Left = Target.Left + Target.Width / 2 - Calendar1.Width / 2 Calendar1.Visible = True Calendar1.Value = Now ElseIf Calendar1.Visible Then Calendar1.Visible = False End If End Sub Private Sub Calendar1_Click() ActiveCell.Value = (Calendar1.Value) ActiveCell.NumberFormat = "dd mmm yy" End Sub
Note in the code the range for the dates is set as A1:A100, maintain the syntax and change this to suit.
Close VB editor.
Exit design mode.
When you click in a1:A100 you get a calendar that defaults to today's date.
Click a date and it gets entered in the active cell.
Fonte Adicionando uma caixa suspensa de calendário ao Excel 2003