Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: ~ IT Competition June 09 ~

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

    Thumbs up ~ IT Competition June 09 ~



    Is month Computer world main ap ko

    "MS Excel Tips & Tricks"
    share karni hain



    Rules :


    • Is Competition Main Post Karnay Ki Last Date Hai 21-06-2009
    • Aik Member Aik Hi Tip share kar sakta hai.
    • Edit Hoi Post Polling Main Count Nahi Ki Jaye gi.
    • Aik Jaysi Ki Hoi Post Main Se Wo Post Count Ho Gi Jo Pehlay Ki Gayi Ho.


  2. #2
    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: ~ IT Competition June 09 ~

    Add Combo Box to a Sheet in Microsoft Excel

    Step 1: Define names
    1.Enter the months list - January-December into the cells A1 to A12 in the new worksheet.
    2.Select cells A!:A12, press Ctrl+F3, enter the text MonthsList into the Names In workbook box,and click OK.
    3.Select Cell B1, press Ctrl+F3, enter the text MonthNumber into the Names in Workbook box, and click OK.


    Step 2: Add a Combo Box to a worksheet

    1. Select one of the toolbars, right-click, and select the Forms toolbar.
    2. Copy the Combo Box by clicking the Combo Box icon, and then release the mouse. Create a rectangle with the mouse in the worksheet, and then release the mouse.

    Step 3: Format the Combo Box


    1.Select the Combo Box; right-click; and from the shortcut menu that appears, select Format Control. Then select the Control tab

    2.In the Input range box, type the name MonthsList (You cannot press F3 to paste a name with an object).
    3.In the Cell link box, type the name MonthNumber.
    4.Click to select the 3-D shading box (more aesthetic).
    5.Click OK.
    Exit the formatting mode of Combo Box, and select a cell in the sheet. Open the list of items in the Combo Box, and select a month. Note that the new month number is shown in cell B1.

  3. #3
    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: ~ IT Competition June 09 ~



    Quickly undo

    Quickly undo mistakes in the majority of most PC Windows program by pressing CTRL + Z.

    8bffd51cd2705b99335ce635a13dbb09 zps81c9bfed - ~ IT Competition June 09 ~

    ..!!


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

    Default Re: ~ IT Competition June 09 ~

    Shortcut to Merge Cells


    Excel allows you to merge cells together in two ways: using the Merge and Center tool on the toolbar, or by using the controls in the Alignment tab of the Format Cells dialog box. If you merge cells quite a bit, you might long for a shortcut that will merge whatever cells you've selected.

    Unfortunately, Excel doesn't include such a shortcut. You can, however, create one using a macro. The following is a simple macro to merge whatever cells you've selected:

    Sub MergeCells1()
    Selection.Merge
    End Sub
    After you create the macro, you can assign it to a keyboard shortcut and you are set to go. If you instead want a macro that is a shortcut for the Merge and Center tool, then you can use the following:

    Sub MergeCells2()
    With Selection
    .HorizontalAlignment = xlCenter
    .Merge
    End With
    End Sub

  5. #5
    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: ~ IT Competition June 09 ~

    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.



  6. #6
    Join Date
    Jun 2009
    Location
    Mama Papa k ghar mein
    Age
    30
    Posts
    53
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanked
    0
    Rep Power
    0

    Default Copy n Paste tip

    Bahio aur Behno itny mushkal tips seekhny k bad mein ap ko aik asaan sa tip bataoon ga


    To copy any cell press Ctrl+C and for paste use Ctrl+V




  7. #7
    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: ~ IT Competition June 09 ~

    ahaan thanks and welcome waqas

  8. #8
    Join Date
    Jun 2009
    Location
    Mama Papa k ghar mein
    Age
    30
    Posts
    53
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanked
    0
    Rep Power
    0

    cute reply 2 sheem

    Ohhhhhh Yeh woh wala Welcome hai
    new wala
    mein tou ghoom he gaya tha thanx n welcome sath sath daikh kr


    Welcome and Thanx sheem
    ab tm mairy tarteeb ko samgny mein 2 mint lagaoo


    yar i m new to ths forum
    can any body tell me k hm competition waly topics mein bhe guppein laga sakty hein yah?????
    Last edited by chwaqasahmed; 08-06-2009 at 03:19 PM.

  9. #9
    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: ~ IT Competition June 09 ~

    no hum nahi gapein laga sakte is topic pe sirf sharing kar sakte hain

    or mujhe 2 mint nahi chund second hi lage bus samjhne mai

  10. #10
    Join Date
    Jun 2009
    Location
    Mama Papa k ghar mein
    Age
    30
    Posts
    53
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanked
    0
    Rep Power
    0

    Default Re: ~ IT Competition June 09 ~

    @sheem
    yar yah tou cheating hoye na
    tmhein kaha bhe tha 2 mint lagaoo aur tm.......
    chaloo choro
    yahan guppein allow nai hein
    tmhein itna bhe nai pata kiya?

Page 1 of 2 12 LastLast

Posting Permissions

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