USE EXCEL VBA!
Write a VBA code to play one round of" Word Game" with 2 questions (each has an answer with 4 characters). In Cell Al, write the text of the first question. You can ask anything you want. Please create 5 different questions and show any of them randomly each time I start the game. There should be 3 buttons on the screen: Start Buy a letter Submit the answer The rules are as below: - There is no time limit. - When I click on Start, show me a question in Cell Al. - The answer should be hidden in A3 to D3 - If I click on "Buy a letter", give me a hint by showing a random letter in the word (it could be any of 4 characters). If I click on this button again, give me another random letter in the answer and so on. To submit my answer, I should fill in the blanks in A3 to D3 and then click on "Submit my answer". When I submit my answer for the question, calculate my score. If my answer is correct I win 400 points minus 100 times of the number of letters I bought. If my answer is wrong I lose 400 points. Show my score in Cell A5. If I click on Start button again, please restart the game for the second round and show me a different question. The same rules will be applied for the second question and when I submit my answer, my final score will be shown in Cell A5. Here is an example. This is how it looks when I click on "Start" button. 1 What's the capital of Italy? START BUY SUBMIT This is how it looks when I click on "Buy" once. 1 What's the capital of Italy? START BUY SUBMIT Write a VBA code to play one round of" Word Game" with 2 questions (each has an answer with 4 characters). In Cell Al, write the text of the first question. You can ask anything you want. Please create 5 different questions and show any of them randomly each time I start the game. There should be 3 buttons on the screen: Start Buy a letter Submit the answer The rules are as below: - There is no time limit. - When I click on Start, show me a question in Cell Al. - The answer should be hidden in A3 to D3 - If I click on "Buy a letter", give me a hint by showing a random letter in the word (it could be any of 4 characters). If I click on this button again, give me another random letter in the answer and so on. To submit my answer, I should fill in the blanks in A3 to D3 and then click on "Submit my answer". When I submit my answer for the question, calculate my score. If my answer is correct I win 400 points minus 100 times of the number of letters I bought. If my answer is wrong I lose 400 points. Show my score in Cell A5. If I click on Start button again, please restart the game for the second round and show me a different question. The same rules will be applied for the second question and when I submit my answer, my final score will be shown in Cell A5. Here is an example. This is how it looks when I click on "Start" button. 1 What's the capital of Italy? START BUY SUBMIT This is how it looks when I click on "Buy" once. 1 What's the capital of Italy? START BUY SUBMIT
