Question: 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
Get step-by-step solutions from verified subject matter experts
