Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started