subject

• Values of Ea, T and A will be entered in an EXCEL spreadsheet by the user. Remember to indicate the units in which the values are to be entered by the user • Assign a button named ‘Calculate k’ that will execute the VBA program and return the value and unit of k to an assigned cell in the spreadsheet • No calculations or other information should be present in the spreadsheet • Have at least three comments in the program • Use Option Explicit • Declare all variables to have local scope • Declare R as a constant equal to 8.314 J/(mol. K) • Use a Sub Procedure named Variables to accept the three values from the cells in the spreadsheet • Pass the values to a Sub Procedure named Calculations to determine the value of k and return it to the spreadsheet rounded to two decimal places

To test your program, use A = 5.24 x 108 L/(mol. min), Ea = 40500 J/mol, T = 345 K

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 05:30
The total revenues for a company are $150,223 and the total expenses were 125,766. if you are calculating the net income, which of these spreadsheets would you use? insert a spreadsheet with $150,223 in cell b2 and 125, 766 in cell b3. enter a formula =b2-b3. the formula should be showing in the formula bar. insert a spreadsheet with $150,223 in cell b2 and 125, 766 in cell b3. enter a formula =b2+b3. the formula should be showing in the formula bar. insert a spreadsheet with $150,223 in cell b2 and 125, 766 in cell b3. enter a formula =b2/b3. the formula should be showing in the formula bar. insert a spreadsheet with $150,223 in cell b2 and 125, 766 in cell b3. enter a formula =b2*b3. the formula should be showing in the formula bar.
Answers: 3
question
Computers and Technology, 22.06.2019 13:30
Jane’s team is using the v-shaped model for their project. during the high-level design phase of the project, testers perform integration testing. what is the purpose of an integration test plan in the v-model of development? a. checks if the team has gathered all the requirements b. checks how the product interacts with external systems c. checks the flow of data in internal modules d. checks how the product works from the client side
Answers: 1
question
Computers and Technology, 23.06.2019 07:00
What are three software programs for mobile computing?
Answers: 1
question
Computers and Technology, 23.06.2019 07:30
To check spelling errors in a document, the word application uses the to determine appropriate spelling. internet built-in dictionary user-defined words other text in the document
Answers: 2
You know the right answer?
• Values of Ea, T and A will be entered in an EXCEL spreadsheet by the user. Remember to indicate th...
Questions
question
Mathematics, 21.05.2021 22:20
question
Mathematics, 21.05.2021 22:20
question
History, 21.05.2021 22:20
question
Biology, 21.05.2021 22:20
Questions on the website: 13722361