Results 1 to 8 of 8

Thread: winner Of IT Comp June 09

  1. #1
    Join Date
    Feb 2008
    Location
    Karachi, Pakistan, Pakistan
    Posts
    125,914
    Mentioned
    836 Post(s)
    Tagged
    9270 Thread(s)
    Thanked
    1180
    Rep Power
    21474971

    snow winner Of IT Comp June 09

    Asalam.o.Alaikum


    IT comp ki winner

    Sheem hain

    inho ne 3 votes se comp win kiya hia




    baki sub ka bhi behad sukriya


    Sheem Tip


    Recording a Data Entry Time


    There are several different ways you can accomplish this task. The first is to manually enter a time by selecting the adjacent cell in column B and pressing Ctrl+Shift+; (that's the semicolon). This shortcut enters the current time in the cell. The problem with this approach, of course, is that it isn't automatic and it takes some extra movement and keystrokes to implement.
    A better approach would be to use a formula to enter the time. The NOW function returns the current date and time, and you can use it in a cell in this manner:
    =NOW()
    Of course, this simple formula is updated every time the worksheet recalculates. That means that the function returns the current time every time you enter a value in column A. This is undesirable because you don't want previous times to update. You could try to use a formula to check to see if something is in column A, as in this manner:
    =IF(A3="","",IF(B3="",NOW(),B3))
    The problem is that a formula like this introduces a circular reference into the worksheet, which presents a whole host of challenges to work with. A better approach is to create a macro that automatically runs every time something is entered in column A. Right-click on the tab of the worksheet used for data entry and choose View Code from the Context menu. You'll see the Code window for the worksheet in the Visual Basic Editor, and then enter this into the window:
    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    Dim rCell As Range
    Dim rChange As Range

    On Error GoTo ErrHandler
    Set rChange = Intersect(Target, Range("A:A"))
    If Not rChange Is Nothing Then
    Application.EnableEvents = False
    For Each rCell In rChange
    If rCell > "" Then
    With rCell.Offset(0, 1)
    .Value = Now
    .NumberFormat = "hh:mm:ss"
    End With
    Else
    rCell.Offset(0, 1).Clear
    End If
    Next
    End If

    ExitHandler:
    Set rCell = Nothing
    Set rChange = Nothing
    Application.EnableEvents = True
    Exit Sub
    ErrHandler:
    MsgBox Err.Description
    Resume ExitHandler
    End Sub
    With the macro in place, anytime you enter something into a cell in column A, the adjacent cell in column B will contain the date and time (formatted to show only the time). If you delete something in column A, then the adjacent cell in column B is cleared, as well.


    صرف آواز نہیں ، لفظ بھی مقفل ہیں مرے

    سوچ میں ہوں کہ اب تجھ کو پکاروں کیسے

  2. #2
    Join Date
    Feb 2008
    Location
    Islamabad, UK
    Posts
    88,506
    Mentioned
    1028 Post(s)
    Tagged
    9706 Thread(s)
    Thanked
    603
    Rep Power
    21474934

    Default Re: winner Of IT Comp June 09



    thanks ji

  3. #3
    Join Date
    Feb 2008
    Location
    Karachi, Pakistan, Pakistan
    Posts
    125,914
    Mentioned
    836 Post(s)
    Tagged
    9270 Thread(s)
    Thanked
    1180
    Rep Power
    21474971

    Default Re: winner Of IT Comp June 09

    umid nahi thi na
    صرف آواز نہیں ، لفظ بھی مقفل ہیں مرے

    سوچ میں ہوں کہ اب تجھ کو پکاروں کیسے

  4. #4
    Iman's Avatar
    Iman is offline Ĵεάℓoμςұ мзάηş !'м ĝя8..
    Join Date
    Jan 2009
    Location
    ς α я α ς н เ
    Age
    29
    Posts
    3,785
    Mentioned
    0 Post(s)
    Tagged
    31 Thread(s)
    Thanked
    0
    Rep Power
    21474848

    Default Re: winner Of IT Comp June 09

    . . . ...
    ...
    .
    .

    .
    .
    .. PℛℐПČΞŚŚ - Ú..
    2po8b3s - winner Of IT Comp June 09



  5. #5
    Join Date
    Mar 2008
    Location
    Mississauga, Canada
    Posts
    35,213
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanked
    0
    Rep Power
    0

    Default Re: winner Of IT Comp June 09



  6. #6
    Join Date
    Mar 2008
    Location
    Canada
    Posts
    25,300
    Mentioned
    0 Post(s)
    Tagged
    442 Thread(s)
    Thanked
    0
    Rep Power
    11381699

    Default Re: winner Of IT Comp June 09




  7. #7
    Join Date
    Jul 2008
    Location
    Karachi
    Age
    28
    Posts
    32,907
    Mentioned
    46 Post(s)
    Tagged
    5939 Thread(s)
    Thanked
    3
    Rep Power
    21474878

    Default Re: winner Of IT Comp June 09




    mk congratulations 3 - winner Of IT Comp June 09

    8bffd51cd2705b99335ce635a13dbb09 zps81c9bfed - winner Of IT Comp June 09

    ..!!


  8. #8
    Join Date
    Aug 2008
    Location
    ~Near to Heart~
    Age
    28
    Posts
    78,521
    Mentioned
    3 Post(s)
    Tagged
    2881 Thread(s)
    Thanked
    0
    Rep Power
    21474924

    Default Re: winner Of IT Comp June 09

    2112kjd - winner Of IT Comp June 09

Posting Permissions

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