[Lesson 10]<<[Table of Contents]>>[Lesson 12] In the previous lesson, we have learned how to use  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 decision structure. The structure of Select … Continue reading Excel 2010 VBA Lesson 11: Using Select Case