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?
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?
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]
Peace of mind is found in some of the strangest places.
I think that will work, I will do some more testing.
Pause time works by seconds? is
[VBA]Pausetime = 10[/VBA]
equal 10 seconds?
yes
Peace of mind is found in some of the strangest places.