This is what I have for 2) of my docs.
The 1st doc
A B
5 START FINISH
6
7
8
9
This doc is one click time. Some times the finish isn't on the same line.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 Then
If IsEmpty(Target) Then Target.Value = Time
End If
If Target.Column = 2 Then
If IsEmpty(Target) Then Target.Value = Time
End If
If Target.Column = 12 Then
If IsEmpty(Target) Then Target.Value = Time
End If
If Target.Column = 10 Then
If IsEmpty(Target) Then Target.Value = Date
End If
End Sub
the date is for a seperate cell
The 2nd doc
A B C D E
1 DATE ACCT# ARR CLR TOTAL
2
3
4
5
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 3 Then
If IsEmpty(Target) Then Target.Value = Time
End If
If Target.Column = 4 Then
If IsEmpty(Target) Then Target.Value = Time
End If
If Target.Column = 1 Then
If IsEmpty(Target) Then Target.Value = Date
End If
End Sub
Again the ARR and the CLR is the concern. If I accidently click on the ARR
/ CLR cells and dont need the cells,The whole formula is gone.
tried a double click in the beginning it didn't work maybe i missed
something from the post.
"Bob Phillips" wrote:
Add a double-click event to do what you want.
--
__________________________________
HTH
Bob
"doss04" wrote in message
...
Thanks that worked. Another question if possible. the cells are set for
time
when i click on them which is what i wanted. The problem i am having now
is
if i click on one of the time cells by mistake. (ie. i dont need the time
in
that cell at that time). When i clear it, it erases the formula in that
cell.
Any ideas?
"Max" wrote:
Rule out calculation mode being inadvertently set to Manual. Take a
moment to
check that calc mode is set to Auto, via clicking Tools Options
Calculation tab.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
---
"doss04" wrote:
I have followed the formulas given for clicking a cell and the time or
date
appears. it worked for a few days. I opened my workbook to start using
some
of the forms i made and the time and dates don't show. When i open the
code
window, the formula is still there. Did i miss something?