Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to control updating of random numbers
I have created a simple worksheet to help my kids practice math facts using
the "randbetween" function, but I also have an IF-THEN-ELSE to show them if they are right. The problem is that as soon as they enter their values, new values are generated and their answer is no longer correct. I went into the options and made calculations manual, but then the answer is not updated either. Is there an easy way to select cells to update automatically (or after pressing a button with a macro) while leaving the others with their original values? =randbetween(-12,12) x =randbetween(-12,12) =IF(B3=B1*B2,"Great!","Try Again") I would like cells B1 and B2 to only be updated manually, but I would like B4 to be updated either automatically or when they are finished with a sheet and hit a button that says "Check answers" or something like that. Thanks! -- Jeff Ciaccio Sprayberry High School Physics & AP Physics Teacher 770-578-3200 AP Physics Site: http://home.bellsouth.net/p/PWP-shsphysics |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to control updating of random numbers
With Calculation set to Manual
From the Immediate Window: ? Range("B4").Calculate Seems to work, So you could Add a Forms Command Button and assign the Macro named UpdateB4 In a standard Module as follows Sub UpdateB4 Sheets("Sheet1").Range("B4").Calculate End Sub "JC Home" wrote in message : I have created a simple worksheet to help my kids practice math facts using the "randbetween" function, but I also have an IF-THEN-ELSE to show them if they are right. The problem is that as soon as they enter their values, new values are generated and their answer is no longer correct. I went into the options and made calculations manual, but then the answer is not updated either. Is there an easy way to select cells to update automatically (or after pressing a button with a macro) while leaving the others with their original values? =randbetween(-12,12) x =randbetween(-12,12) =IF(B3=B1*B2,"Great!","Try Again") I would like cells B1 and B2 to only be updated manually, but I would like B4 to be updated either automatically or when they are finished with a sheet and hit a button that says "Check answers" or something like that. Thanks! -- Jeff Ciaccio Sprayberry High School Physics & AP Physics Teacher 770-578-3200 AP Physics Site: http://home.bellsouth.net/p/PWP-shsphysics |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to control updating of random numbers
Jeff,
I made up a "Math Practice" worksheet using macros. It provides random numbers between -12 and 12 in B5:C20 with column D for answers (multiplication) and column E with the answer prompt. Has two buttons on the sheet: New Test and Check Answers. It might be of some help or give you some ideas for your own solution. Glad to send it along. Email me at XX (remove XXX from email address) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "JC Home" wrote in message I have created a simple worksheet to help my kids practice math facts using the "randbetween" function, but I also have an IF-THEN-ELSE to show them if they are right. The problem is that as soon as they enter their values, new values are generated and their answer is no longer correct. I went into the options and made calculations manual, but then the answer is not updated either. Is there an easy way to select cells to update automatically (or after pressing a button with a macro) while leaving the others with their original values? =randbetween(-12,12) x =randbetween(-12,12) =IF(B3=B1*B2,"Great!","Try Again") I would like cells B1 and B2 to only be updated manually, but I would like B4 to be updated either automatically or when they are finished with a sheet and hit a button that says "Check answers" or something like that. Thanks! -- Jeff Ciaccio Sprayberry High School Physics & AP Physics Teacher 770-578-3200 AP Physics Site: http://home.bellsouth.net/p/PWP-shsphysics |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
(djn) Excel Not Updating Random Cells | Excel Discussion (Misc queries) | |||
Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) |