Question: Please write code that will run in VBA excel for the following problem Paragraph Styles Ask the user to think of a number between 1

Please write code that will run in VBA excel for the following problem
Please write code that will run in VBA excel for the following

Paragraph Styles Ask the user to think of a number between 1 and 9. Then use a series of message boxes to give the user the following instructions: -Multiply their number by three. Add three to the result. Multiply the whole thing by three. Add the digits of their final number together. You will read their minds as they look at their fortune on the spreadsheet and highlight the message corresponding to their final number even though you do not know what number they originally picked! Here are some specific instructions about how I want you to do the above problem. Read all these instructions carefully. Do not waste time doing things that I am hot asking you to do. 1. put your code in a module. 2.Use four variables to hold the four instruction bullets above (one variable per instruction.) 3.Use five message boxes. One to give the user the original instruction about thinking of a number, and one using each of the four message variables. 4.Highlight cell B10. To fill in a cell use the following on a range object: Interior. Colorindex = 26. 7 Note, you do not need to ask the user for the number they are choosing or do any calculations. Only do the things you are being asked to do in these instructions. If you ask them for their number, you are not reading their mind

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!