View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default date format static

Are you using xl97 and data|Validation?

Debra Dalgleish shares this:
http://contextures.com/xlDataVal08.html#Change

(The easiest fix may be typing the names into the data|validation dialog.)

Wanna Learn wrote:

Thanks Lynn
Example
If I select a name from the drop down box in B59
C59 remains blank instead of giving me the date and time

"Lynn Trapp" wrote:

When you say that the macro doesn't work, what do you mean? What is happening
when you run it?

Lynn Trapp

"Wanna Learn" wrote:

Hello I copied the following macro and I entred the macro n the worksheet
module this is what I'm looking for. If one of the following cells is not
blank B59, B 60 B 61 B 63 but has a name that has been selected from a drop
down box then in column c I want a static current date and time Macro
does not work thanks for your help
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count 1 Then Exit Sub
If Not Intersect(Range("B59:B63"), .Cells) Is Nothing Then
Application.EnableEvents = False
If IsEmpty(.Value) Then
.Offset(0, 1).ClearContents
Else
With .Offset(0, 1)
.NumberFormat = "dd mmm yyyy hh:mm:ss"
.Value = Now
End With
End If
Application.EnableEvents = True
End If
End With
End Sub


--

Dave Peterson