Wednesday, August 10, 2011

Vba sub using scores, sorting, input boxes?

scores are in columns B through E. Students are listed in A. Write a vba sub that (a) uses an input box to ask for an exam from 1 to #, (b) uses an input box to ask if they want to sort the scores in ascending or descending order and (c) then sorts data requested and the order requested. Make sure headings in row 3 are not sorted. write sub to allow for more or fewer exams and/or more or fewer students.

No comments:

Post a Comment