I haven't read through the code, either, but it happens. Heck, the bulk of it is just an ElseIf ladder with relatively small blocks. Nothing surprising about that.

My point is that you make it sound like the code is less right because it is a long method. As long as the code works, it is only less right if there is an alternative way to write the same thing such that it is more efficient. When it comes to Select Case and ElseIf ladders, that generally doesn't happen.