Limits on Case Statements

T

Todd Huttenstine

Hey guys

Is there a limit on the amount of cases you can have in a
case statement?


Thanks in advance
Todd
 
P

pikus

What is the function you are aiming for? Depending on that you may b
going about this the wrong way... Just a thought...

In the meantime, like this

Select Case ComboBox1.Value
Case 1
{DoStuff}
...
Case 52
{doStuff}
End Selec
 
T

Tom Ogilvy

If you ask this question, there is probably a better way to do what you
want. No way of knowing, but if there is a definable pattern or a way to
calculate things, it might be advisable.
 
T

Todd Huttenstine

Hey thanx to all who reponded. I ended up making a loop
which was much more practical.
 
Top