Hello,
I have been working on this for awhile and still not coming up with what i need.
Every leads will be appreciated.
***
Write a macro that does the following actions:
The macro asks the user to make the sum of two numbers while the answer is not correct.
When the user finds the right answer, the macro will write in cell A1 the number of tries necessary to find the right answer.
You can write these two numbers directly in the code of the macro.
****
Thank You.
Your first post is about a homework problem?
See the faq: http://www.vbaexpress.com/forum/faq....q_hom_faq_item
A homework assignment.
You will need at least one Variable to hold the number of attempts.
You can use two more variables to hold the numbers.
Then you can use an InputBox to ask the User the question.
It will probably be easier to understand the code if you use a fourth variable to hold the answer
You will need to use a loop such as
Do While Not Answer = Sum(Var2, Var3)
Answer = CLng(InputBox blah blah blah)
Var1 = Var1 + 1
Loop
Range("A1") = Var1
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
Show us what you have so farOriginally Posted by kme.amoah
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3
Posting Permissions
Reply With Quote
