Form Picture help

[Emoncada]

I wanted to know if this is possible.

Is it possible when someone clicks a button for it to make a picture visible for a certain amount of seconds then hide the picture?

[austenr]

try something like this untested:

replace the msgbox logic with your picture

[vba]Sub exceltimer()
Dim PauseTime, Start, Finish, TotalTime
If (MsgBox("Press Yes to Get a Break Reminder", 4)) = vbYes Then
PauseTime = 10
Start = Timer
Do While Timer < Start + PauseTime
DoEvents
' your routine here

Loop
Finish = Timer
TotalTime = Finish - Start
MsgBox "Break lasted for " & TotalTime & " seconds"
Else
End
End If
End Sub[/vba]

[Emoncada]

I think that will work, I will do some more testing.

[Emoncada]

Pause time works by seconds? is
[VBA]Pausetime = 10[/VBA]

equal 10 seconds?

[austenr]

yes