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

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

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!