Results 1 to 4 of 4

Creating Random numbers in Excel problem

Threaded View

  1. #1
    Registered User
    Join Date
    10-06-2008
    Location
    Odense
    Posts
    27

    Creating Random numbers in Excel problem

    Hi all

    I have a difficult one here.

    1. I have to make a VBA makro that can generate calculus pieces (2 numbers added to each other) for 2.nd grade students. The Program has to generate Random easy calsulus as shown on the
    picture. It has to be 30 pieces of (+) Caluculus distributed with 5 horisontally and 6 vertically.

    2. A user has to be able to put a minimum and a maximum value of the sum of numbers generated. So if the user puts 20 and 40 the sum of the numbers it is creating can only be between those 2 number. say 11+11, 22+10 etc.

    3. Also the student has to be able to try and solve the solve the calculations by typing in his or her answer under the randomly generated numbers.

    4. VBA
    Then has to go through all the calculations to see if the student made a
    right, wrong or no answer at all.

    5. The final results will have to be displayed in a message box. e.g. "there are
    30 assignments solved with the following results, 22 correct, 1 missing and
    3 wrong answers".

    Please see attached photo for a better understading.

    Thanks in advance. If any questions please ask me.
    Attached Images Attached Images

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