Re: MultipageSeite alle 5 sek. wechseln
03.02.2003 17:03:54
Felix
Hallo,mein bisheriger Code sieht so aus, nur bin ich leider nicht in der Lage den Wechsel zustande zu bekommen.
Mit den Schleifen hab ich es noch nicht so.
Gruß
Felix
Private Const giIntervall As Integer = 1
Private Const gsMacro As String = "BildWechsel"
Private gdNextTime As Double
Private i As Byte
Private Sub CommandButton1_Click()
Call WechselEnde
Unload Me
End Sub
Private Sub UserForm_Initialize()
MultiPage1.Value = 0
WechselEin
Call BildWechsel
End Sub
Sub BildWechsel()
Select Case i
Case Is = 0
MultiPage1.Value = 1
Case Is = 1
MultiPage1.Value = 2
Case Is = 2
MultiPage1.Value = 3
Case Is = 3
MultiPage1.Value = 4
Case Is = 4
MultiPage1.Value = 5
Case Is = 5
MultiPage1.Value = 0
End Select
Call WechselEin
End Sub
Sub WechselEin()
gdNextTime = Now + TimeSerial(0, 0, giIntervall)
Application.OnTime earliesttime:=gdNextTime, procedure:=gsMacro, schedule:=True
End Sub
Sub WechselEnde()
On Error Resume Next
Application.OnTime earliesttime:=gdNextTime, procedure:=gsMacro, schedule:=False
End Sub