Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
May 18, 1999

Always Use Case Else With Select Case

Select Case statements can lead to errors when the test expression in the Select Case line doesn't yield a true result for any of its individual Case expressions. Therefore, you should always use a Case Else as the final Case within a Select Case statement. This sample raises a custom error when an application invokes the Select Case statement with an operation other than the four basic ones:
 
Select Case Operation
	Case "Addition"
		Computer2 = dblNumber1 + _
			dblNumber2
	Case "Subtraction"
		Computer2 = dblNumber1 - _
			dblNumber2
	Case "Multiplication"
		Computer2 = dblNumber1 * _
			dblNumber2
	Case "Division"
		Computer2 = dblNumber1 / _
			dblNumber2
	Case Else
		Err.Raise 1, , "Wrong operation."
End Select
Rick Dobson
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date