A Better Proper Case Function

Function PCase(strInput)
	'Variable declaration.
	dim strArr
	dim tmpWord
	dim tmpString
	dim last
	
	
	'Create an array to store each word in the string separately.
	strArr = split(strInput," ")
	
	
	if ubound(strArr) > 0 then
		for x = lbound(strArr) to ubound(strArr)
			'Set each word to lower case initially.
			strArr(x) = LCase(strArr(x))
	
			
			'Skip the unimportant words.
			select case strArr(x)
				case "a"
				case "an"
				case "and"
				case "but"
				case "by"
				case "for"
				case "in"
				case "into"
				case "is"
				case "of"
				case "off"
				case "on"
				case "onto"
				case "or"
				case "the"
				case "to"
				case "a.m."
					strArr(x) = "A.M."
				case "p.m."
					strArr(x) = "P.M."
				case "b.c."
					strArr(x) = "B.C."
				case "a.d."
					strArr(x) = "A.D."
				case else
				
					'Capitalize the first letter, but don't forget to take into account that
					'the string may be in single or double quotes.
					if len(strArr(x)) > 1 then
						if mid(strArr(x),1,1) = "'" or mid(strArr(x),1,1) = """" then
							tmpWord = mid(strArr(x),1,1) & Ucase(mid(strArr(x),2,1)) & mid(strArr(x),3,len(strArr(x))-2)
						else
							tmpWord = Ucase(mid(strArr(x),1,1)) & mid(strArr(x),2,len(strArr(x))-1)
						end if
						strArr(x) = tmpWord
					end if
					
			end select
			
			
			'The unimportant words may need to be capitalized if they follow a dash, colon,
			'semi-colon, single quote or double quote.
			if x > 0 then
				if instr(strArr(x-1),"-") _
				or instr(strArr(x-1),":") _
				or instr(strArr(x-1),";") then
					tmpWord = Ucase(mid(strArr(x),1,1)) & mid(strArr(x),2,len(strArr(x))-1)
					strArr(x) = tmpWord
				end if
			end if
			
		next
	else
		strArr(0) = LCase(strArr(0))
	end if
	
	
	'Make sure the first word in the array is upper case, but don't forget to take into account
	'that the string may be in single or double quotes.
	if mid(strArr(0),1,1) = "'" or mid(strArr(0),1,1) = """" then
		tmpWord = mid(strArr(0),1,1) & Ucase(mid(strArr(0),2,1)) & mid(strArr(0),3,len(strArr(0))-2)
	else
		tmpWord = Ucase(mid(strArr(0),1,1)) & mid(strArr(0),2,len(strArr(0))-1)
	end if
	strArr(0) = tmpWord
	
	
	'Also, make sure the last word in the array is upper case, but don't forget to take into account
	'that the string may be in single or double quotes.
	last = ubound(strArr)
	if mid(strArr(last),1,1) = "'" or mid(strArr(last),1,1) = """" then
		tmpWord = mid(strArr(last),1,1) & Ucase(mid(strArr(last),2,1)) & mid(strArr(0),3,len(strArr(last))-2)
	else
		tmpWord = Ucase(mid(strArr(last),1,1)) & mid(strArr(last),2,len(strArr(last))-1)
	end if
	strArr(last) = tmpWord
	
	
	'Rebuild the whole string from the array parts.
	for x = lbound(strArr) to ubound(strArr)
		tmpString = tmpString & strArr(x) & " "
	next
	
	PCase = tmpString
End Function