SELECT CASE

[DS]

How many Select Case's can you have before the whole thing starts
getting funky? 10? 20? 30?
Thanks
DS

 

[Dirk Goldgar]

How many Select Case's can you have before the whole thing starts
getting funky? 10? 20? 30?

I don't know if there's a limit. I know I've never reached it. Feel
free to set up a test to see if you can identify a limit. However, I
suggest that if you're writing a procedure where you fear you may run
into a limit, you may not be going about your coding in the most
efficient way. You may be able to factor out common elements of the
code and handle the process by passing some value to a parameterized
procedure.

 

[DS]

I don't know if there's a limit. I know I've never reached it. Feel
free to set up a test to see if you can identify a limit. However, I
suggest that if you're writing a procedure where you fear you may run
into a limit, you may not be going about your coding in the most
efficient way. You may be able to factor out common elements of the
code and handle the process by passing some value to a parameterized
procedure.

Thanks Dirk,
Well I ran a test on 25 and it worked fine. But I figure I'll just make
3 seperate forms, which will give me 3 Select Case's of 13, 12, and 4.
This way I don't have to go to deep into the code! I'm just trying to
re-use as many forms as possible since I've noticed that I have forms
that are used again just because of a line or two of code. So I think
less is more and more is less
Thanks Dirk,
DS