SELECT CASE

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

How many Select Case's can you have before the whole thing starts
getting funky? 10? 20? 30?
Thanks
DS
 
DS said:
How many Select Case's can you have before the whole thing starts
getting funky? 10? 20? 30?
Click to expand...

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.
 
Dirk said:
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.
Click to expand...
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
 
Back
Top