Results 1 to 2 of 2

Insert Date & Time to a neightbouring column when I double click in column A

Threaded View

contaminated Insert Date & Time to a... 07-04-2011, 11:40 AM
contaminated Re: Insert Date & Time to a... 07-04-2011, 12:05 PM
  1. #1
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Insert Date & Time to a neightbouring column when I double click in column A

    I swear God, this code was working yesteday.. but not today....

    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    
    ' Çàïóñê ôîðìû ââîäà ïî äâîéíîìó øåë÷êó ïî ÿ÷åéêå
        On Error Resume Next
        If Not Intersect(Target, Range("A1:A1000")) Is Nothing Then
            Cancel = True
            If Target.Offset(-1, 0) <> vbNullString Then
                If Target = vbNullString Then
                    Range("F" & Target.Row) = Date + Time
                End If
            End If
        End If
    End Sub
    Last edited by contaminated; 07-04-2011 at 12:21 PM.
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, ?Born in USSR?
    Vusal M Dadashev

    Baku, Azerbaijan

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1