|
- Sub GetTime()
- Dim vMsg As Variant, nI As Integer, bFlag As Boolean, nDate(1 To 2) As Integer
-
- vMsg = Split("|请输入年份:|请输入月份:", "|")
- Do While nI < 2
- nI = nI + 1
- bFlag = True
- Do
- nDate(nI) = Application.InputBox(prompt:=vMsg(nI), Type:=1)
- If nDate(nI) = 0 Then
- Exit Sub
- ElseIf nI = 1 Then '年份
- If nDate(nI) < 2000 Or nDate(nI) > 2030 Then
- MsgBox "输入年份不在2000~2030年之间!请重输!"
- Else
- Exit Do
- End If
- Else '月份
- If nDate(nI) < 1 Or nDate(nI) > 12 Then
- MsgBox "输入的不是月份的数值!请重输!"
- Else
- Exit Do
- End If
- End If
- Loop
- Loop
- MsgBox "输入的年月是:" & nDate(1) & "-" & Format(nDate(2), "00")
- End Sub
复制代码 |
|