Is there a limit to how many terms you can stick in a Case Selection?

[Paul_Hossler]

So ignoring the logic of this for a moment, is there a limit to how much you can stick inside a Case (definitions)?

1

http://www.vbaexpress.com/forum/show...of-Case-select

2.

I wouldn't write it that way


3. IIRC (and going back many^2 years) Case Select was a 'Switch' and an integer (maybe byte) was computed to jump directly to the appropriate Case. FORTRAN called something like this a Computed GoTO

Case Select is oft times advertised as an alternate to a bunch of If / Then / Elseif / ..... but I'd think that each If / Elseif has to be evaluated there's a lot more CPU cycles involved with all that testing

So instead of testing 100 Elseif's, Case Select just says 'Go to the 100th Case'



Not sure about any of this