Case statement

[smi]

I am using Excel 97 with Win 95. I have a project with a lot of If and
ElseIf statement. It work but not very clean programming.
I am looking for Case statement example on the net.
Thank you for your time.

Long

 

[Chip Pearson]

A Select Case statement if quite simple, and fairly well documented in the
VBA help files. A simple example of Select Case is

Dim X As Integer
X = 3
Select Case X
Case 1
MsgBox "X=1"
Case 2
MsgBox "X=2"
Case 3
MsgBox "X=3"
Case Else
MsgBox "X = something else"
End Select



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Dave Peterson]

I searched google for "select case" and found over 7000 posts in the *excel*
newsgroups:

http://groups.google.com/groups?q="select+case"+group:*excel*

Here are a couple by Chip Pearson:

http://www.cpearson.com/excel/DateTimeEntry.htm
and
http://www.cpearson.com/excel/DateTimeEntry.htm