Question: 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

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

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!