Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this is microsoft Excel question QUESTION 3) Create a Sub called silly Sub: Define 3 VBA Variables as Integer (james, fontColor, back Color) Use the

image text in transcribed
this is microsoft Excel question
QUESTION 3) Create a Sub called silly Sub: Define 3 VBA Variables as Integer (james, fontColor, back Color) Use the VBA Variable james in a loop from 3 to 9. and include the following inside the loop: Set the VBA Variable fontColor to a random number between 1 and 56 Set the VBA Variable backColor to a random number between 1 and 56 Chage the Excel cell in the spreadsheet at Row james, and Column james + 2 Set the cell value to james 5 Set the font colour of the cell using Font Colorindex to the VBA Variable fontColor Set the background colour of the cell to the VBA Variable backColor QUESTION 4) Create a Sub called silly Loops: It must have 4 loops to produce the 4 patterns in the tab "Q.4 Loops

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Database 101

Authors: Guy Kawasaki

1st Edition

0938151525, 978-0938151524

More Books

Students also viewed these Databases questions

Question

What is the difference between Needs and GAP Analyses?

Answered: 1 week ago

Question

What are ERP suites? Are HCMSs part of ERPs?

Answered: 1 week ago