Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started