Microsoft Office Forums - View Single Post - Question about Case statement

Thread: Question about Case statement

View Single Post

Old

01-05-2013, 02:30 PM

Jennifer Murphy Jennifer Murphy is offline

Jennifer Murphy is offline

Jennifer Murphy uses Windows XP

Windows XP Jennifer Murphy uses Office 2007

Jennifer Murphy uses Office 2007

Office 2007

Competent Performer

The original poster

Join Date: Aug 2011

Location: Silicon Valley

Posts: 234

Jennifer Murphy is on a distinguished road

Default

I found the answer. Just code a list.

Code:

Select Case UCase(MyString)
   Case ""
     MsgBox "Macro aborted", , MyName
   Case "A"
     Call SubA
   Case "B", "F", "S", "T", "V"
     Call SubMisc
   Case "G"
     Call SubG
   Case Else
     MsgBox "Invalid data"
End Select

Reply With Quote