+ Reply to Thread
Results 1 to 3 of 3

Is VB the answer to my problem??

  1. #1
    Registered User
    Join Date
    07-02-2008
    Location
    London, England
    Posts
    2

    Is VB the answer to my problem??

    Hi

    My first post here, so here goes!

    I work as a Maths teacher and have created some tasks for my students in Excel. I have used IF formulas to create a Correct and Incorrect scenario (which I have hidden) and then I have used a COUNTIF formula to count the number of CORRECT to give the student instant feedback on the number they have done correctly. I have attached the file for you to look at!

    My question is - is it possible to create a button and attach a VB script which will mark the answers and return a score (i'm certain it is!?)

    and

    if this is possible is it possible that when the MARK IT button is clicked the script send the returned score to another file with the student name or emails it to a give email address?

    Just wondering if this is possible? I don't possess (personally) the VB skills to do this but wanted to know if it was possible first before pursuing this route.

    Any help or guidance (or a better/easier way) would be great!

    Thanks Everyone!

    J Banks
    Attached Files Attached Files

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    What you need is certainly doable.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    07-02-2008
    Location
    London, England
    Posts
    2
    Any pointers to where I should start looking???

    Thanks

    J

+ Reply to Thread

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