Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write the following table on Excel (Sheet 1) and open the VBA window and insert a new module. Student number student name length 160001 Sara

Write the following table on Excel (Sheet 1) and open the VBA window and insert a new module. Student number student name length 160001 Sara george 160002 Ahmed sami 160003 omran stewart 160004 John thiele 160005 Fatima miska 160006 floransa a) Write a code in a module which reads the student Name Column and put the length of their names in column "C" (in front of each student name). Use Do while Loop. b) Draw a Button and name it by length in order to run the code without open the VBA window c) Write a code in another module to color first, third, fifth of student number (Blue) and student name (Yellow). Use For..Next Loop. (ColorIndex is 5 for Blue and 6 for Yellow)

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_2

Step: 3

blur-text-image_3

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

MySQL Crash Course A Hands On Introduction To Database Development

Authors: Rick Silva

1st Edition

1718503008, 978-1718503007

More Books

Students also viewed these Databases questions