Results 1 to 3 of 3

Thread:

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Jan:2011
    Location:
    Posts: 2

    .
    VBA .
    : , . , . 2 B2 , F2 G2 ..

    Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.Count > 1 Then Exit Sub

    If Target.Column > 1 Then Exit Sub

    Target.Offset(0, 1) = Now


    End Sub

  2. #2
    Registered User
    Join Date: Aug:2009
    Location:
    Posts: 265
    Quote Originally Posted by homescare View Post
    .
    VBA .
    : , . , . 2 B2 , F2 G2 ..

    Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.Count > 1 Then Exit Sub

    If Target.Column > 1 Then Exit Sub

    Target.Offset(0, 1) = Now


    End Sub
    :
    Code:
        If Target.Column <> 1 And Target.Column <> 5 Then Exit Sub
    , , F .

  3. #3
    Registered User
    Join Date: Jan:2011
    Location:
    Posts: 2
    .

Posting Permissions

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

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |