+ Reply to Thread
Results 1 to 5 of 5

Test Paper with cell Selection in a given time

  1. #1
    Registered User
    Join Date
    03-16-2013
    Location
    karachi
    MS-Off Ver
    Excel 2003
    Posts
    40

    Test Paper with cell Selection in a given time

    Dear All,
    I just want to select a cell(Specific cell) means when i select a specific cell then "yes" is pasted in it. and also i want to introduce a timer of 2 minute like in a paper(if no cell is selected and if the timer end then nothing is pasted).
    Thanks


    Sub test()
    Dim a As Integer
    If Range("B3").Activate Then
    Range("B3").Value = "Yes"
    If Range("B9").Activate Then
    Range("B9").Value = "Yes"
    If Range("B14").Activate Then
    Range("B14").Value = "Yes"
    End If
    End If
    End If
    End Sub
    Last edited by syed01; 12-22-2013 at 08:29 AM.

  2. #2
    Registered User
    Join Date
    03-16-2013
    Location
    karachi
    MS-Off Ver
    Excel 2003
    Posts
    40

    Re: Auto Test Paper

    Dear All,
    like if i select Cell (B3 or B9 or B14) from my mouse within 2 min then "yes" is pasted in it and if i select any cell then nothing to do.

  3. #3
    Registered User
    Join Date
    03-16-2013
    Location
    karachi
    MS-Off Ver
    Excel 2003
    Posts
    40

    Re: Auto Test Paper

    Any comment plz

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Auto Test Paper

    Hi, syed01,

    you should consider to give this thread a more meaningful title as requested per Forum Rule #1.

    And please let 24 hours pass before you bump your post.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  5. #5
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Test Paper with cell Selection in a given time

    Hello syed01,

    Maybe something along the attached sample Workbook?

    Regards
    Attached Files Attached Files
    Last edited by Winon; 12-24-2013 at 04:24 AM.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Test Paper
    By syed01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-26-2013, 04:45 AM
  2. Auto Grading of test
    By chulo7683 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-13-2013, 04:41 AM
  3. Excel Test Question Paper needed
    By luckyros in forum Excel General
    Replies: 7
    Last Post: 03-03-2011, 05:44 AM
  4. Pull sub-test scores from test w/best overall test score (PSAT)
    By PowerSchoolDude in forum Excel General
    Replies: 0
    Last Post: 11-19-2009, 08:29 PM

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