Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Classwork/Homework #8: VBA Basic Objects and Properties Complete by Friday-print out the code and submit at the beginning of class on Friday. Make sure your
Classwork/Homework #8: VBA Basic Objects and Properties Complete by Friday-print out the code and submit at the beginning of class on Friday. Make sure your name is on it. Instructions: Write a VBA module/program/code (with a unique subroutine name) that: a) Gets number values from 2 different cells in EXCEL. The column is the same initial as your first name (i.e. If your name is Bob, you will get values from B1, B2, etc.). Use Row 1 and 2 b) Use the RANGE command for one number and the CELLS command. Assign those values to variables in your code. Make one variable name your first name, the other variable name your last name c) Add those values and assign it to a third variable called "TotalName" in your code. d) Put the third variable value in Row 3. Use the Cells command. e) Use the Range command to make the third variable cell font size 24
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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