Question: Question 2: Write the following table on Excel (Sheet 1) and open the VBA window and insert a new module. Student number student name length
Question 2: 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 roads the student Name Column and put the longth 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 rm the code without open the VBA window c) Write a code in another mochile 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
Get step-by-step solutions from verified subject matter experts
