不需要算闰年。每个月的最后一天都可以从下月1日减1天得到:Dim i As IntegerPrivate Sub Combo2_Click() Dim datTmp As Date
datTmp = DateAdd("m", 1, Combo1 & Combo2 & "1日") - 1 Combo3.Clear For i = 1 To Day(datTmp) Combo3.AddItem i & "日" Next i Combo3.ListIndex = 0 End SubPrivate Sub Form_Load() For i = 2000 To 2020 Combo1.AddItem i & "年" Next i Combo1.Text = Year(Date) & "年"
For i = 1 To 12 Combo2.AddItem i & "月" Next i Combo2.ListIndex = 0 End Sub
Dim datTmp As Date
datTmp = DateAdd("m", 1, Combo1 & Combo2 & "1日") - 1
Combo3.Clear
For i = 1 To Day(datTmp)
Combo3.AddItem i & "日"
Next i
Combo3.ListIndex = 0
End SubPrivate Sub Form_Load()
For i = 2000 To 2020
Combo1.AddItem i & "年"
Next i
Combo1.Text = Year(Date) & "年"
For i = 1 To 12
Combo2.AddItem i & "月"
Next i
Combo2.ListIndex = 0
End Sub