Private Sub Command1_Click()
Dim Year As Integer
Dim Name As Integer
Year = InputBox("请输入年份:")
Label1.Caption = Str(Year) + "年的生肖为:"
Name = Year Mod 12
Select Case Name
Case 4
Label2.Caption = "鼠"
Case 5
Label2.Caption = "牛"
Case 6
Label2.Caption = "虎"
Case 7
Label2.Caption = "兔"
Case 8
Label2.Caption = "龙"
Case 9
Label2.Caption = "蛇"
Case 10
Label2.Caption = "马"
Case 11
Label2.Caption = "羊"
Case 0
Label2.Caption = "猴"
Case 1
Label2.Caption = "鸡"
Case 2
Label2.Caption = "狗"
Case 3
Label2.Caption = "猪"
End Select
End Sub
我运行了这段程序,可是inputbox弹出的对话框我一选择“清除”命令就会出现错误
请高手帮忙
Dim Year As Integer
Dim Name As Integer
Year = InputBox("请输入年份:")
Label1.Caption = Str(Year) + "年的生肖为:"
Name = Year Mod 12
Select Case Name
Case 4
Label2.Caption = "鼠"
Case 5
Label2.Caption = "牛"
Case 6
Label2.Caption = "虎"
Case 7
Label2.Caption = "兔"
Case 8
Label2.Caption = "龙"
Case 9
Label2.Caption = "蛇"
Case 10
Label2.Caption = "马"
Case 11
Label2.Caption = "羊"
Case 0
Label2.Caption = "猴"
Case 1
Label2.Caption = "鸡"
Case 2
Label2.Caption = "狗"
Case 3
Label2.Caption = "猪"
End Select
End Sub
我运行了这段程序,可是inputbox弹出的对话框我一选择“清除”命令就会出现错误
请高手帮忙
或者用个中间变量
Dim s As String
s=inputbox(...)
if s<>"" then
year=iif(s = "", 0, val(s))
end if
Private Sub Command1_Click()
Dim Year As Integer
Dim Name As Integer
On Error Resume Next
Year = InputBox("ÇëÊäÈëÄê·Ý£º")
If Len(Year) < 4 Then
MsgBox "ÇëÊäÈëÕýÈ·µÄÄê·Ý"
Exit Sub
End If
Label1.Caption = str(Year) + "ÄêµÄÉúФΪ£º"
Name = Year Mod 12
Select Case Name
Case 4
Label2.Caption = "Êó"
Case 5
Label2.Caption = "Å£"
Case 6
Label2.Caption = "Ȣ"
Case 7
Label2.Caption = "ÍÃ"
Case 8
Label2.Caption = "Áú"
Case 9
Label2.Caption = "Éß"
Case 10
Label2.Caption = "Âí"
Case 11
Label2.Caption = "Ñò"
Case 0
Label2.Caption = "ºï"
Case 1
Label2.Caption = "¼¦"
Case 2
Label2.Caption = "¹·"
Case 3
Label2.Caption = "Öí"
End Select
End Sub
Dim Year As String
Const SX As String = "猴鸡狗猪鼠牛虎兔龙蛇马羊"
Year = InputBox$("请输入年份:")
If Len(Year) And Val(Year) > 0 Then
Label1.Caption = Year + "年的生肖为:"
Label2.Caption = Mid$(SX, Year Mod 12 + 1, 1)
End If
End Sub