Search
  • Kalpesh Agrawal

VBA Select Case Statement

The select case statement is an alternative to the If-Then statement, this allows you to test if conditions are met, running specific code for each condition.


Let’s see an example of this…

When you press the run button you will get the following pop-up window.







If you enter a valid number as an example 3, you will get the message box as below.






If you enter a valid number as an example 8, you will get the message box as below.








0 comments

Recent Posts

See All