Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions