[VBA] Ignore Upper and Lower Case letter

[Alexlin]

Hi Guys, thanks for reading my post. I've encounter another VBA problem again.
The situation is I needa check if the country provided is within my own country list. So I've written below:-

Function BSD(Place As String) As String

Select Case Place
Case "China", "Cyprus", "Czech Republic", "Denmark", "Hungary", "Iceland", "India", "Indonesia", "Ireland", "Israel", "Italy", "Jamaica", ", "Norway", "Pakistan", "Philippine"
BSD = "True"
Case Else
BSD = "False"

End Select

End Function


However, for example, if the country is "CHINA", "ChInA", "chINA", or other combinations, the code that I wrote above could not match my list. Is there any way to solve this problem?? How to modify my code?

Thanks in advance for your help! Have a nice day!

 

[steve the fish]

Use UCase or LCase so

Select Case UCase(Place)

then

Case "CHINA"

etc.

 

[Alexlin]

Use UCase or LCase so

Select Case UCase(Place)

then

Case "CHINA"

etc.

Thanks Steve! It works.
Just dun understand how come it works.
Simply use Ucase an change all the case to capital letter, so it could match ignore the case sensitive.

 

[Michael M]

Don't need to change the code itself
simply add the line at the beginning

[color=red]Option Compare Text[/color]
Function BSD(Place As String) As String

Select Case Place
Case Is = "China", "Cyprus", "Czech Republic", "Denmark", "Hungary", "Iceland", "India", "Indonesia", "Ireland", "Israel", "Italy", "Jamaica", "Norway", "Pakistan", "Philippine"
BSD = "True"
Case Else
BSD = "False"

End Select

End Function