Function a()
Dim i&, j&, k
ReDim k((2050 - 2012) \ 4)
For i = 2012 To 2050 Step 4
k(j) = i
j = j + 1
Next
a = k
End Function
Dim i&, j&, k
ReDim k((2050 - 2012) \ 4)
For i = 2012 To 2050 Step 4
k(j) = i
j = j + 1
Next
a = k
End Function
解决方案 »
- Listview等控件的item支持单击功能吗?
- 怎样才能在picturebox里画一个与photoshop相同效果的选区,谢谢
- format的问题2
- 如何用ado或rdo执行sqlserver2000 的 Exec指令?
- 求教电子地图的编程思路
- 救命啊!!!!!!!!!(指教)
- 关于菜单问题!!
- vb的语句问题
- 新手请教:怎么在VB中编写Checkbox的值(其对应Access中的yes/no值)
- ActiveX component can't create object?????????????????
- 请教高手,怎样把文本型"3分23秒"此类的转换成203秒!
- 急问:Access中如何用vb编写 将文本框输入的日期,加入到sql的search判据当中去
用call调用的函数无法取得返回值-_-
n = 0
Y = 2010
Do Until (Y > 2050)
If Y Mod 4 = 0 Then
If (Y Mod 100) <> 0 Then
leap = 1
ElseIf (Y Mod 400) = 0 Then
leap = 1
Else
leap = 0
End If
Else
leap = 0
End If
If leap = 1 Then
Print Y;
n = n + 1
If n Mod 5 = 0 Then
Print
End If
Y = Y + 1
Loop
End SubPrivate Sub cmdleap_click()
Print "2010年至2050年之间的闰年:"
Call FindLeap
End Sub
运行的时候,提示Loop缺少do ????
Private Sub FindLeap()
Dim i As Long
For i = 2010 To 2050
If IsDate(CStr(i) & "-2-29") Then
Debug.Print i
End If
Next
End Sub
n = 0
Y = 2010
Do Until (Y > 2050)
If Y Mod 4 = 0 Then
If (Y Mod 100) <> 0 Then
leap = 1
ElseIf (Y Mod 400) = 0 Then
leap = 1
Else
leap = 0
End If
Else
leap = 0
End If
If leap = 1 Then
Print Y;
n = n + 1
If n Mod 5 = 0 Then Print'这里有问题,if end if 不配对
End If
Y = Y + 1
Loop
End SubPrivate Sub cmdleap_click()
Print "2010年至2050年之间的闰年:"
Call FindLeap
End Sub
n = 0
Y = 2010
Do Until (Y > 2050)
If Y Mod 4 = 0 Then
If (Y Mod 100) <> 0 Then
leap = 1
ElseIf (Y Mod 400) = 0 Then
leap = 1
Else
leap = 0
End If
Else
leap = 0
End If
If leap = 1 Then
Print Y;
n = n + 1
If n Mod 5 = 0 Then Print'这里改一下
End If
Y = Y + 1
Loop
End SubPrivate Sub cmdleap_click()
Print "2010年至2050年之间的闰年:"
Call FindLeap
End Sub
n = 0
Y = 2010
Do Until (Y > 2050)
If Y Mod 4 = 0 Then
If (Y Mod 100) <> 0 Then
leap = 1
ElseIf (Y Mod 400) = 0 Then
leap = 1
Else
leap = 0
End If
Else
leap = 0
End If
If leap = 1 Then
Print Y;
n = n + 1
If n Mod 5 = 0 Then Print'这里改一下
End If
Y = Y + 1
Loop
End SubPrivate Sub cmdleap_click()
Print "2010年至2050年之间的闰年:"
Call FindLeap
End Sub
Print Y;
n = n + 1
If n Mod 5 = 0 Then
Print
End If
'改为
If leap = 1 Then
Print Y;
n = n + 1
End If
If n Mod 5 = 0 Then
Print
End If
Dim i As Integer
Dim datTemp As Date For i = 2010 To 2050
datTemp = GetLastDate_Month(DateSerial(i, 2, 1))
If Day(datTemp) = 29 Then
Debug.Print i
End If
Next i
End SubPrivate Function GetLastDate_Month(ByVal datDate As Date) As Date
GetLastDate_Month = DateAdd("d", -Day(DateAdd("m", 1, datDate)), DateAdd("m", 1, datDate))
End Function
Dim i As Integer
With CreateObject("scripting.dictionary")
For i = 2010 To 2050
If Day(DateSerial(i, 3, 0)) = 29 Then .Add i, Nothing
Next
MsgBox Join(.keys, vbCrLf)
End With
End Sub