Excel 2010 VBA Lesson 11: Using Select Case

 [Lesson 10]<<[Table of Contents]>>[Lesson 12] In the previous lesson, we have learned how to write Excel 2010 VBA  code using If….Then….Else statement. However, for multiple options, the If…Then…Else structure could become too bulky and difficult to debug. Fortunately, Excel  2010 VBA provides another way to handle complex multiple-choice cases, that is, the Select Case…End Select … Continue reading Excel 2010 VBA Lesson 11: Using Select Case