In an Excel formula can the clock be used to measure time?
 

I am developing an Excel model that tests the participant's memory.
Commencing the program makes a sheet visible. I want to use a
"Worksheet_Change macro to hide the sheet after a specified period of time
(between 30 & 90 seconds). Can the computer's clock be associated with a
formula so that I can cause a value in a cell to change at the conclusion of
a selected period? I am using Windows XP Home with Office 07.

In an Excel formula can the clock be used to measure time?
 

this should hide the sheet after 2 seconds after A1 is changed


Private Sub Worksheet_Change(ByVal Target As Range)
Const WSrange As String = "A1"
Dim i As Long
If Not Intersect(Target, Me.Range(WSrange)) Is Nothing Then
Application.Wait (Now + TimeValue("0:00:02"))
ActiveSheet.Visible = xlHidden
End If

End Sub

--


Gary


"Charlie Betz" wrote in message
...
I am developing an Excel model that tests the participant's memory.
Commencing the program makes a sheet visible. I want to use a
"Worksheet_Change macro to hide the sheet after a specified period of time
(between 30 & 90 seconds). Can the computer's clock be associated with a
formula so that I can cause a value in a cell to change at the conclusion of
a selected period? I am using Windows XP Home with Office 07.

In an Excel formula can the clock be used to measure time?
 

don't need the dim statement, put it there by mistake


Private Sub Worksheet_Change(ByVal Target As Range)
Const WSrange As String = "A1"
If Not Intersect(Target, Me.Range(WSrange)) Is Nothing Then
Application.Wait (Now + TimeValue("0:00:02"))
ActiveSheet.Visible = xlHidden
End If

End Sub

--


Gary


"Charlie Betz" wrote in message
...
I am developing an Excel model that tests the participant's memory.
Commencing the program makes a sheet visible. I want to use a
"Worksheet_Change macro to hide the sheet after a specified period of time
(between 30 & 90 seconds). Can the computer's clock be associated with a
formula so that I can cause a value in a cell to change at the conclusion of
a selected period? I am using Windows XP Home with Office 07.

In an Excel formula can the clock be used to measure time?
 

This may assist:
http://www.mrexcel.com/archive/VBA/7422a.html

Corey....



"Charlie Betz" wrote in message
...
I am developing an Excel model that tests the participant's memory.
Commencing the program makes a sheet visible. I want to use a
"Worksheet_Change macro to hide the sheet after a specified period of time
(between 30 & 90 seconds). Can the computer's clock be associated with a
formula so that I can cause a value in a cell to change at the conclusion
of
a selected period? I am using Windows XP Home with Office 07.