Limits on Case Statements

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
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
 
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
 
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.
 
Hey thanx to all who reponded. I ended up making a loop
which was much more practical.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code character limit with Resize or Transpose or cell? 8
populate cells using select case 3
Select Case 4
Select case syntax for continuous range values? 1
Select Case or If - What's the difference 3
Start Do/Loop within conditional statement 4
Debug.Print statement causes Excel crash 7
Wildcards in a case statement 5

Back
Top