L
Legacy 420921
Guest
i have question time that counter for code
how i get to start when you open the file witout click anywhere in a cell
TY Thomas
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)[/FONT][/COLOR]
[COLOR=#000000][FONT=Courier]Dim hour As Boolean[/FONT][/COLOR]
[COLOR=#000000][FONT=Courier]hour = Not (hour)[/FONT][/COLOR]
[COLOR=#000000][FONT=Courier]Do While hour = True[/FONT][/COLOR]
[COLOR=#000000][FONT=Courier]DoEvents[/FONT][/COLOR]
[COLOR=#000000][FONT=Courier]Range("A3") = TimeValue(Now)[/FONT][/COLOR]
[COLOR=#000000][FONT=Courier]Loop[/FONT][/COLOR]
[COLOR=#000000][FONT=Courier]End Sub
how i get to start when you open the file witout click anywhere in a cell
TY Thomas