Question about Case statement

		Microsoft Office Forums > Microsoft Word > Word VBA
Question about Case statement

FAQ

Thread Tools

Display Modes

01-05-2013, 02:30 PM

Jennifer Murphy Jennifer Murphy is offline

Windows XP Question about Case statement

Office 2007

Competent Performer

Join Date: Aug 2011

Location: Silicon Valley

Posts: 234

Jennifer Murphy is on a distinguished road

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Regular expressions: lower case after hyphen	SusanG	Word	2	06-06-2012 11:58 PM
Custom Text Filter for this particular case	tinfanide	Excel	2	09-13-2011 05:08 AM
Case Sensitive (contains) Selection	apolloman	Excel	2	07-12-2011 04:50 AM
From all UPPER CASE to Proper Case	davers	Word	1	04-30-2009 12:41 PM
Upper to lower case	jd	Excel	1	04-28-2006 07:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:25 PM.